Extract Date Cell from Each File to Create Date Column

[jpt1228]

Hello, I am trying to figure out how to extract the date which resides in a column with a sales quantity. Each month I receive a file that is in the same format with the exception that the date column changes to the most recent year and month. There is an example to the lower left. I need to transform the date into a date column. When I combine the files the first date carries down through the next dates so it looks like I only have 1 month of data. I could do a work around to add the date in the file name and then extract the date into a date column, but that involves me renaming the file each time I import.

I receive the data like the bottom Left and want it to look like bottom right any suggestions?

	Item	Qty	2018 - 4		Item	Qty	Date
	A	2	2		A	2	2018 - 4
	B	1	1		B	1	2018 - 4
	C	4	4		C	4	2018 - 4
	Item	Qty	2018 - 5		A	3	2018 - 5
	A	3	3		B	2	2018 - 5
	B	2	2		C	1	2018 - 5
	C	1	1

[v-jiascu-msft · Accepted solution]

Hi @jpt1228,

Please check out the demo in the attachment. 

Best Regards,

Dale