Merging Data From Multiple Files Into One

[bwlytkr]

I am looking for a way to merge the data from multiple files and columns into one file. I have 5 files with the same column names and want to move all the data in those columns into one column in one file. For Ex; these columns appear in each file and I need the data from these to appear in one file with the same column names. I've never done any merging of files or code writing so, I'm not sure where to go from here. Any help would be appreciated. Thanks

DATE SENT TO SOC	#DAYS WITH SOC	# Days with SOC Category	Priority	SOURCEONE DEADLINE DATE	DaysAged	NTG DAYS Age Bucket	Construction Director	TicketNumber	State
1/18/2022​	29​	G- < 30 DAYS OLD	2​	2/7/2022​	34​	F - 30-60 DAYS OLD	JONES, ROBERT E	4213991​	AL
1/24/2022​	23​	G- < 30 DAYS OLD	2​	2/13/2022​	27​	G- < 30 DAYS OLD	JONES, ROBERT E	4112369​	AL
1/24/2022​	23​	G- < 30 DAYS OLD	2​	2/13/2022​	27​	G- < 30 DAYS OLD	JONES, ROBERT E	4032458​	AL

 

[Kerryx]

Power query Data_ From folder

Select Combine & Transform

 

[bwlytkr]

thanks. worked great

 

[Kerryx]

Glad to help , if you could confirm the solution it will help others in the same situation in the future to find a suitable answer