Excel Power Query is Joining Text Files Together - Need them on seperate Rows

Hi

I am importing many files in to excel. They are text files. Using PowerQuery. They have about 40 lines of data in them, all on separate lines.

0945996
G ANDERSON
1405
Saturday 8th

etc etc

I want it to show going across so each line of data is in its own column - all across Row 1. So each text file has its data across the same Row, and lines of data in column A B C etc.

But when I import all the txt into power query, I click on content and it joins them all together so all the data from all files is in column A going all the way down.

Using normal Data import for the text file I can get it to work, but it will only do one file at a time. Need to use Power Query to get the whole folder in...

Should look like (you might need to be on Desktop not mobile to view this properly):

`
Row Column A Column B Column C Column D
1 0945996 G ANDERSON 1405 Saturday 8th
2 0855686 A WATKINS 4774 Weds 4th
3 0644844 K WILSON 1855 Thursday 11th
`

http://superuser.com/questions/94238...parate-rows-ba

Thanks.

That works pretty well! Thanks. I should be back when I hit the next hurdle! Thanks.