Forum Discussion
Combing TXT files with different columns
Hi - I am trying to combine several TXT files that have different columns, so not all the columns are being captured. I found a few ways of doing it, but that assumes the header is already establishe...
In Power Query, you can use Merge to bring them altogether. Basically, when you have one or more columns that you want to bring together, you can merge them.
Let me know if you want me to provide further steps.
Theo 🙂
Yes, please! How do you do that exactly? Thank you so much?
Here is a basic tutorial: https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9
Go to the "Perform a Merge Operation" section.
Hopefully this helps.
Theo 🙂
TheoC Thanks! but this requires me bringing in one file at a time right? The folder of files I am bringing will have a new file each week.
