How to RESHAPE Horizontally Stacked data into a table with Power Query #powerbitutorial

In this video you will learn how to reshape multi column horizontally stacked data into a table, with Power Query. Chapter Links: 00:05 Review the source data and understand the challenge 00:56 Connect to the data source (.xlsx file) 02:27 Review and cleanup the (Auto) Applied Steps 03:09 The technique to reshape multi column horizontally stacked data 06:47 The technique to promoting headers when it is not in the first row! 09:31 Applying the data types - the right way (Date "Using Locale") 11:30 Close and apply the transformations and load data 11:50 Applying the right formatting to Date and Currency fields Link to the exercise file: https://tinyurl.com/ywzvr4et Thanks for watching this video.If you have any questions regarding the concept covered in this video, then please leave a comment and I will get back to you. Like & Subscribe: https://youtube.com/@biwithgurpreet #powerquery #powerbitutorial #biwithgurpreet #datapreparation #dataanalytics #powerquerytutorial #datacleaning #datacleansing