Hi,
I have an Excel file as source in Data Factory which has multiple rows for column headers and blank columns as separators. May I know what would be the best approach to transform this dataset into a single dataset?

My idea is to make it like:
Header 1 Subhead 1
Header 1 Subhead 2
Header 2 Subhead 3
Header 2 Subhead 4
But I don't know how to realize it :(
Also I have blank columns which I delete manually in Select function. Is there any way I can select columns in the Dataset options?

