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//youtube.com/celiaalvessolveexcel
Get access to the video EXERCISE FILES by joining our Telegram Group at [ Ссылка ] (For this video, search for "T0017" on my Telegram channel. - same files as for this video: [ Ссылка ])
Subscribe to my NEWSLETTER for exciting news about the Excel world: [ Ссылка ]
Solve & Excel Consulting - [ Ссылка ]
LinkedIn: [ Ссылка ]
Facebook: [ Ссылка ]
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
