Forum Discussion
error in pivot column
hi all..i am trying to pivot column"merged" but got error. can anyone advice where i have gone wrong... Thank you so much.
Hi,
See if my solution here helps - Append data from multiple worksheets of multiple workbooks where each worksheet has a different heading.
The second file is not in the same format as the one you posted earlier.
The second one has a Merge column which contains the data from 2 columns in the first file, so that's why it's not working