How to RESHAPE Multi-Column Stacked Data into a table with Power Query #powerbitutorial

preview_player
Показать описание
In this video, you will learn how to reshape multi column vertically stacked data, with Power Query, into nicely formatted tabular format.

Chapter Links:
00:00 Introduction
01:05 Review the source data and understand the challenge
03:30 Connect to the data source (.xlsx file)
05:01 The technique to reshape multi column vertically stacked data
08:52 Data Cleanup
10:30 Save transformations and import data
13:09 Outro

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 #powerbitutorial #biwithgurpreet #datapreparation #dataanalytics #powerquerytutorial #datacleaning #datacleansing
Рекомендации по теме
Комментарии
Автор

Thanks and awesome trick. Question: what is the purpose of the integer column ? Could you not have gotten the modulo just from the index column ?

decentmendreams
Автор

This trick is really useful! Excellent video, very well explained and quick to watch! Thank you so much!

fernandocardinali
Автор

Sir, I am grateful to you for this particular video. It has been of tremendous use. God bless you 🙏🏻
Take ❤

imranahamed
Автор

Amazing video thanks mate, I’ve an got an exam coming up where I need to utilise power query so this was a massive help

WilliamSymonds-iz
join shbcf.ru