I learned how to create a Multiple Consolidation Ranges pivot table, but I am having trouble getting it to do anything useful.
Say I have data from A1:B5000 and from F1:G5000. I want to create a pivot table that would be the same as pasting the 2nd range into C1:D5000, and creating a new range A1:D5000.
I'm not trying to superimpose the data on top of each other, I just want it side-by-side. Everything in each row is related and I have 4 separate columns of information, they just aren't in 4 consecutive columns. I tried creating a "dummy" sheet and using INDEX to import the data so they sit next to each other, but doing so for such a large index seemed to crash excel. Any ideas?
Bookmarks