Hi,
I need help I have headers that are dates. I would like all the dates in one column, and would even like to be able to have years and months in there own column as well. I have tried to do this in PQ but having a little trouble. My headers currently are Partner, Region, Market, then header dates 1/1/2023, 2/1/2023 etc. I am trying to make awesome pivot tables showing performance measures and not successful. Please assist.
Hi,
In PQ, first unpivot your data table. Select the Partner, Region and Market columns. Then "unpivot other columns". You'll end up with a much longer table, but with only 5 columns. The three you already had plus two extra. One is called Attribute (holding the dates). The other is called Value (holding the measures). Rename these as you like. Make sure you set the data type to Date for the date column.
When you then create a pivot table Excel should automatically add date intelligence that allows you to work with Years, Quarters and Months.
Should you get stuck, please come back here.
Hi Rinny,
Thank you for providing that info that part worked with combining columns but it does not give me the option for years, quarters, and months and my dates column won't sort in chronological order. Please assist.
Can you provide a file? Otherwise we'll be guessing as to what type of data you are working with.
