Multiple Header Rows: Power Query Data Transformation Guide

[@kebincui]

Super ❤👍

[@howtolearnexcel]

Thanks! Btw, if you'll deal with a large data set, there is another approach you may like too: kzbin.info/www/bejne/n37IppyqZq6ce5Y It'll work a bit faster because it avoids the double transposition.

[@FsoOmar]

Great I loved it, especially the Parse Date. I've never seen it before. I usually just change the Data Type.

[@howtolearnexcel]

Thank you! Both approaches are pretty similar. Parsing turns text into a date, while changing the type makes sure Power Query treats the data as a date, which only works if the data is already in a date-friendly format. A slight difference in error handling.

[@FsoOmar]

@@howtolearnexcel Aha, thank you for explaining the difference. Appreciate your response. 🤝

[@howtolearnexcel]

An alternative approach is covered here (by @basensei8699 ): kzbin.info/www/bejne/n37IppyqZq6ce5Y

[@hands-on-data]

Yours is better

[@samitube007]

Thanks , if you can provide the data spreadsheet it will be easy to practice. … anyway.

[@howtolearnexcel]

Sorry, here it is: docs.google.com/spreadsheets/d/11WpVGlYJLuJAgreN16MvwCoTTGPeKZp-/edit?usp=drivesdk&ouid=108776671615330203341&rtpof=true&sd=true