Hello,
I have the following input data:
And i need to parse it to get this output:
I wonder if there is a way to get a row as header and the information bellow as row.
Thank you.
Solved! Go to Solution.
You can use a sample to remove extra rows at the top, and a dynamic rename to get the first row of data (after the sample) to be the headers.
You can use a filter with regex to grab the proper rows with actual data.
Are you able to upload the excel file? I can mock a workflow for you.
There might be a better way to do it but the way I would go about it is filter out the 'not-required' rows based on the first column value being a letter or a number and then use the Dynamic Rename tool to use the first row as the header.