Stored Values With Separate Columns

[betboogieman]

I have been trying to store some values in excel for separate events, for tracking purposes. But the data is messy and exported in the same columns. I know when exported as text it is correct. My hope is to use power query and merge all the data from all separate spread sheets into one master sheet. I would much appreciate help as I am currently at a road block and stuck. If there a easier ways to achieve the same outcome then I'm all ears.