Hello everyone,
I am trying to concatenate the first column of multiple txt files in the same folder and have that data in an excel sheet.
(I want to create an excel sheet with each column containing the first column of the respective txt file)
I think that I should use power query.

Up to now this is what I am doing :
Data -> get data -> from file -> from folder -> select folder
Then I think that I need to select "Combine & transform data" or "Transform data", but from that point I am lost.
Is there someone that could potentially help me?

Thank you in advance!