Transform "MS Excel 97-2003" data files stored in a folder path into a read-able table for

[geeklarokcmie]

Hello Experts,

I currently have folder path where MS Excel 97-2003 files are received - macros are run on each excel file to convert them to read-able table format (csv).

I tried transforming in Alteryx but it doesn't work and keeps failing. How can I achieve this?

Input - sample file attached

Expected Output with column headers as below and all the rows of data under those column headers - without any page breaks and duplicate column headers

Date 5/1/2023

IT Account	Cg Bal	Ad Bal	Difference
**D TAL**	********	*****	*****
1000252222	********	*****	*****

[Raj · Accepted solution]

@geeklarokcmie 
is this same 
Remove empty Rows and adjust the rows consistently - Alteryx Community
please close if this is duplicate and solved.

Regards

Raj

[geeklarokcmie]

Yes, It is  similar to my other post. Will close this as suggested.