How to RESHAPE Single Column stacked data into a Table with Power Query #powerbitutorial

In this video, you will learn how to reshape single column stacked data, with Power Query, into nicely formatted tabular format.

Chapter Links:
00:00 Introduction
01:03 Review the characteristics of source data
02:26 Connect to the data source (.txt file)
05:08 The technique to reshape single column stacked data
08:45 Data Cleanup
12:05 Save transformations and import data
13:09 Recap

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.

#powerquery #powerquerytutorial #powerbitutorial #biwithgurpreet

[donaldbanda]

Thoroughly explained, I feel very confident and inspired to tackle any project now 🎉❤❤❤ because of your bro . Guys let’s shoot his gus to reach subscribers in 4 weeks … I will share his channel everywhere and everyday

[khalidmajeed]

good for every one because explanation is in easy need more iin power query

[rodneyreddy]

guru bhai thanks for the tutorial, u have a very pleasing voice which makes the tutoria; very listenable, hadnt bored in any part of the video
bhai if possible plzz make a complete tutorial 4m start to finish not like thse individual videios, bcse so many of us 4m diff backgrounds, so we wouldnt be having clarity like where to start and finsh may be this style will work for already working professionals in the IT, thanku bhai its just a suggestion thou, implement only if its ok 4u

[HG-Tech]

Great video, very helpful. How did you figure out this process?

[kimsanov]

Hello! Thanks for video. I have 2 questions - why do we need integer division column? And how to make inverse task – e. g. I have two rows in table (row 1 is A, B, C and row 2 is D, E, F) and I need to get single column with A, B, C, D, E, F stacked vertically (and with blank cell between each 3 rows. Like Excels TOCOL function does. Thanks

[jaitiwari]

Plz create dashboard project on power bi