How to make Power Query deal with a variable number of columns in a text source file

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

4,589

When reading data from text files, sometimes the conversion to columns is not consistent. Source files produced the same way, expected to present the same number of columns, may be interpreted by Power Query differently and show a variable number of columns from file to file. This video shows a tweak that can help deal with that situation and make Power Query deal with any number of columns it finds in the data source.

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

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 (For this video, search for "T0017" on my Telegram channel. - same files as for this video:    • Produce automatic video captions on S...  )

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

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