Forum Discussion
How do I change column headers to a variables under a single column?
Hi all, I have a dataset with the first column header of 'SKU List' with 3000 SKUs listed. The next 10 columns headers are sales from 2010 to 2020 and the contents in the cells are the number of ...
pheerful Connect to the entire table with PowerQuery. Select the first column. Right-click and select Unpivot other columns. Close and load back to a table.
Thank you for the response. I cannot install PowerQuery as it is a company laptop and they are very strict about what we do. Is there an alternative solution other than manually inserting/transposing? We do have access to macros.