Forum Discussion
Sub-category columns Excel
Hi All, I am trying to create a report from an excel file but my file data is set-up such that the column has a sub category. e.g I have this as an excel format, how do I subcategorize ...
Hi,
I solved a similar problem here - Rearrange a multi heading dataset into a single heading one which is Pivot ready.
Hope this helps.
Hi,
Thank you! This is very helpful. Just not sure if how this will work on extremely massive data set.
Many thanks,
Matt
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Have you resolved the issue? please mark the helpful reply as answer, and welcome to share your own solution. More people will benefit from here.
Regards,
Cherie