Transform raw data into a proper table format

[db89]

Hello all,

I have a raw data set (sample Test Template 2) which has columns Type of Cost, Cost amount and Firm.

The challenge I am facing is, I am not able to get the raw data  structured in the 'Output' sample attached and have each data exported into multiple tabs based on the Firm name.

I would request, if anyone could provide a bit of guidance on this then it will be really helpful. 

Thanks,

db89 

[Yoshiro_Fujimori]

Hi @db89 ,

It was difficult for me to deal with "Total" raw as your sample.

As a workaround, I added "Raw Type" to differentiate Total raw from the original raws.

Also it was difficult to split the tables to separate Excel sheets.

So I output to PDF instead.

It may not be exactly what you expect, but I hope it may be of some hint.

Workflow

[db89]

Hi @Yoshiro_Fujimori,

Really appreciate your response! 

This will something likely break the usual format I am willing to create, at the same time it would be required to get in multiple sheets. But really appreciate for guiding on this.