Transform raw data into a proper table format

Question

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

OUTPUT.xlsx

Test Template2.xlsx

db89 · Answer

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.

Yoshiro_Fujimori · Answer

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

1272405.yxmd