Hi all,
I am looking to extract data from merged excel template in to a simple format as shown in the output file. I tried multiple ways but without any luck as I was able to extract only what was there in the left side.
Can anyone assist.
Hi @Saravanan13 ,
You can extract data from kind of "dirty" sheets by specifying columns and rows with Select Records and Select tools.
Then you can transform the table with Cross Tab and/or Transpose tools, when necessary.
Here is a sample workflow to show you sample patterns of above process.
You should be able to apply one of the patterns to the rest of the rows.
Good luck.
Workflow
Output