Data Transformation Required

[DataPirate26]

Hi team, 

I have shared a small dataset below. I need to transform the Dataset into the required Output Format ( Attached below). Can someone help me to achieve this format. 

[binuacs]

@DataPirate26 Some of your totals are not matching with my total. Can you check whether they are correct?

[Zok]

Hello

I did that very quickly so you will probably need to adjust if you have more than one LOS or if you want to delete some fields, but your solution will be around anything like Sub-Total workflows

[Christina_H · Accepted solution]

Here you are

[DataPirate26]

@Christina_H very Precise and efficient Solution you have provided. Thanx a lot