Forum Discussion
pheerful
Aug 19, 2021Copper Contributor
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 ...
Riny_van_Eekelen
Aug 19, 2021Platinum Contributor
pheerful From Excel 2016, PQ is integrated in Excel. So you are on an older version?
pheerful
Aug 19, 2021Copper Contributor
I am using Excel on Mac and I don't think PowerQuery is supported natively yet on my version at least.
- Riny_van_EekelenAug 19, 2021Platinum Contributor
pheerful Okay, then you may forget it!