How to unstack data in repeated groups of rows in the same column with Power Query in Excel

Опубликовано: 22 Октябрь 2024
на канале: Celia Alves - Solve & Excel

7,867

213

When your data comes stacked in one column only with information that belongs to multiple fields and should be distributed in various columns, use this recipe in Power Query. Do this work once and enjoy your data structured in a tabular layout forever!

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

New videos on YouTube every week: https:www//   / celiaalvessolveexcel

Get access to the video EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel (search for the files for tutorial “T0017” – Full tutorial available at:    • Produce automatic video captions on S...   )

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn:   / celiajordaoalves

Facebook:   / solveandexcel

Twitter: @celia_excel

Instagram: @solveandexcel

#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

#Excel #shorts #solveandexcel #microsoft365 #microsoft #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #powerquerytraining #powerqueryeditor #worksmarternotharder #canada #msexceltraining #microsoftexceltips