Forum Discussion
Compiling two worksheets - help please!
I need to compile data from two worksheets. I need them to match up data based off an order number that is in both worksheets, and the data associated with that order number from both worksheets be ...
I didn't explain very well. I don't want anything to sum together. So, both worksheets have an order number listed. I need everything associated with a specific order number to combine on to one row in a new worksheet. But in that row, each value from the first two worksheets still needs its own column.
That could be done with Power Query:
- name data range for first sheet (e.g. "RangeOne") and for second one;
- query both ranges in separate connection query, filter in each empty records;
- merge both queries (inner join) and land the result in new sheet.
Please see attached.