Combine text files with different column headings side by side using Power Query in excel

preview_player
Показать описание
Three text files in a folder where the first column is the same but the second column is different in each file.
---------------------------------------------------------------------------------
#exceltutorials #exceltips #powerquery

Microsoft Office 365, Beta Channel, Version 2204
---------------------------------------------------------------------------------
  1. Karina Adcock
  2. combine text files in excel
  3. combine files using excel
  4. combine tables using excel
  5. combine spreadsheets with excel
  6. combine files with powerquery
Комментарии
Автор

thank you very much for this - it saves me a lot of time. I have been looking for this solution. 🙏🏻

LS-zocr
Автор

Thank you so much! There's a good chance that I have just saved the world, and it's all thanks to you.

nlgyuxr
Автор

I have 4 csv files. When I expand the selection of columns it doesn’t find ALL the columns? It varies with whichever csv files is the Sample. Is there a bug or some other setting needed?
Otherwise - this is great information!!

robertmalcolm