1
vote
0answers
21 views

Excel Need to Check one Sheet for Data if True take data and paste in field

I am doing inventory for my company but need to use last years inventory prices in this years quarterly spreadsheet. There are only 3 Information fields. SKU, Qty, and Cost. In the master it has SKUS ...
1
vote
1answer
26 views

How do I sort and merge data (in Excel) with hexadecimal codes?

I take attendance in large, lecture classes. Each student inputs a vote on a multiple-choice question with a "clicker" (a hand-held, remote control device), and each clicker has a 6-digit, ...
0
votes
0answers
18 views

merge and combine in excel

I have two sheets in excel, in both of them, I have a column a as ID but ID in both sheets are not the same. both of them have some ID number that does not exist in another. there are several column ...
0
votes
1answer
41 views

How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...
1
vote
3answers
11k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
-2
votes
1answer
276 views

Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...
1
vote
2answers
3k views

merge two rows in excel worksheet where one cell has same content but other cells have different content

My problem is that in my excel worksheet of several thousand entries the item (eg widget a) is included in more than one row, with different attributes listed in the different rows. Aside from the ...
0
votes
1answer
301 views

Combine 2 excel sheets having common values in one column

I've 2 excel sheets . I want to combine them based on common values in a particular column. Example: if excel-A has values like this orderNo Product C1-231 Spares C1-232 Back-Ups C1-242 ...
1
vote
2answers
2k views

Merge Excel rows from two sheets

I'd like to start this question by apologizing, there are numerous questions about merging excel rows, still, after browsing the web AND the list of "Questions that may already have your answer", I ...
0
votes
2answers
335 views

Merging 2 spreadsheets on Excel 2010

I was wondering if it was possible to merge data from 2 different spreadsheets together. I'm looking at at world development indicators, so I have 1 spreadsheet which has human development index ...
1
vote
3answers
3k views

Excel 2010: How can I obtain a one-to-many rows table by merging duplicated cells in a large normalized table?

As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue - how to get a one-to-many rows table out of ...
1
vote
2answers
152 views

Formula to merge column from sheetA to sheetB to matching ID

Match unique id Sheet1!A2 to a cell in Sheet2!A2:A100 that has the matching ID. Paste cell content from column Sheet2!C2:C100 from the same row with the matching id in Sheet2 to the cell with formula ...
1
vote
1answer
353 views

Microsoft Excel 2003 - Merge by Column

I'm trying to merge two excel files, here is the structure of the files: [A] [B] I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
1
vote
1answer
4k views

Excel, merge two sheets with one column as key

Let me start by saying I exclusively use Excel to view things and that's where my experience ends. I have two sheets with some common data, and most importantly, a column in each that has the same ...
2
votes
2answers
11k views

How to merge two Excel columns into one?

Let's say we have two columns/ranges A1:A10 (group A) and B5:B50 (group B) and we need to merge the two into one column in C1:C60 (60 in C = 10 from A + 50 from B) Data in group A & group B can ...
1
vote
0answers
1k views

Excel with Version Control - Best way to merge excel files?

What is the best way to allow multiple users to edit the same excel file and later merge the files together with conflict resolution?
5
votes
4answers
13k views

How can I merge hundreds of Excel spreadsheet files?

I have hundreds of excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 all singing and dancing file which must have the same format ...
1
vote
1answer
629 views

How to automatically merge a .xls file and a .csv file to one Excel sheet?

I have an Excel sheet in .xls file. I want to merge it with a .csv file, so that the data in the .csv file will be added starting from the first empty row in .xls. I want to be able to do it ...
0
votes
1answer
195 views

Excel: while merging column contents using ampersand I “lose” zeros

I need to merge different columns like: AB 0054 00000137 I do it this way =A1&B1&C1 It works but my Zeroes get lost. The text in my columns has been formatted in "personal" with zeroes ...
2
votes
1answer
672 views

Two Spreadsheets, Merge Data?

I was wondering what is the best way to merge two spreadsheets which have the name id's e.g: One sheet has: apple 5 dog 3 cat 2 Second sheet: dog 4 apple 7 cat 3 I would ...
2
votes
2answers
2k views

Merging duplicate rows in Excel 2003

I have a spreadsheet with two columns in the format: title A 300 title B 345 title A 25 title C 105 I would like to merge the rows with duplicate titles while totaling the numeric value so ...
1
vote
2answers
988 views

Merge two Excel sheets

I have two 'tabs' in my Excel file and I would like to merge the two tabs into one sheet (in the same file). The two files look somthing like: artnr language description price artnr ...
3
votes
4answers
13k views

Merging two cells in multiple rows

I have an excel spreadsheet with two cells in each row that I'd like to merge. Highlighting all the cells of interest and just merging from the cell formatter seems to just merge all the cells ...
1
vote
1answer
206 views

Merging cells in Excel 2007 because the web exporter is a punk

I have to use a web site to export data in XLS format, to be converted to CSV, to be dumped into a MySQL database. My problem is that this POS exporter treats carriage returns in the original data as ...
0
votes
2answers
572 views

excel - merge cells including a zip code

I have the need to merge a bunch of cells that comprise an address (street, city, state, zip) into a single cell. No problem except with the zip code. The zip cell has only 4 digits for any zip ...
0
votes
2answers
469 views

Excel - working with multiple workbooks

Got about 50 workbooks that cannot be merged but need to make the data available in a nice easy way. Aany ideas how to open and close multiple workbook modally i.e control remains in some interface / ...
0
votes
1answer
3k views

Simple Merge / Purge with Excel

I have four Excel files that contain email addresses. I need to find out how many unique addresses are in the first three, but not in the fourth. What's the easiest way to do that?