I have a workbook with three sheets I want to combine on one worksheet. Each workbook has a common identifier for the row. I need to pin the data for each common identifier together. Each sheet is a different length of rows . . . the common denominator is the pin number. I've tried to create pivot table, but at the address fields (which I want to remain in column categories on their own), pivot table tries to lump into a separate subcategory. Help. So close and yet so far.
Solved by D. L. in 28 mins