How to extract data from prefilled template

[Saravanan13]

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.

[Yoshiro_Fujimori]

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