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
Hi,
You are welcome. Please try it and let me know how it works.