0
votes
1answer
68 views

Consolidate multiple data rows with three common elements and add specific values from each row

I need to consolidate 400.000 rows of order level data, by order number, while adding the ship quantity for each row with the same order number. I need to consolidate multiple data rows with three ...
2
votes
2answers
6k views

Find alike data in two worksheets and put in 3rd worksheet

What is the best/easiest way to combine data from two different Excel spreadsheets into a third Excel spreadsheet? Spreadsheet 1 will have the username only. Spreadsheet 2 would have lots of ...
0
votes
1answer
939 views

Combine multiple rows into one

I am trying to combine multiple rows of data into one. Column A contains the value on which the groupings will be based -- rows whose Column A values match will be combined into one row. My range ...
2
votes
2answers
3k views

Make Excel cell save formula results and not the actual formula?

I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a ...
0
votes
1answer
3k views

merging two excel files into one

I have two files with multiple worksheets in each that I would like to combine into one file. I want the formulas to remain but without the association to the old file.