Forum Discussion
A little help!
Okay so, being pretty knowledgeable in excel (I think) I am having a little trouble and im not sure if its just my brain is on overload or I may not know exactly what im doing please bear with me as ...
If you can get rid of the merged cells you should be able to use Get & Transform to consolidate the data from all the tabs and create a pivottable from there.
