Forum Discussion
Query for multiple txt files with all data in one column
Using PAD I can extract data from docx to txt files, because later I want to build a database from that. All txt files have data in multiple lines in one column. The problem is, Power Query combines...
Hi Bartbobbrt
How do you read the txt files? In a folder? Can you add a custom column to transpose prior to combine the tables? Removed all the other columns to see it clearly
Table.AddColumn(#"Removed Columns", "Custom", each Table.Transpose( Table.FromColumns({Lines.FromBinary(([Content]), null, null, 65001)})))