How to easy transpose the table to want form?

Question

Dear all ,  how to do split rows by group to columns of dynamic way ?

Input  Output  TypeValue ProfitCostRevenueProfit10

1040100Profit20 2020400Profit30 3030200Profit20 2010300Cost40  30400Cost20    Cost30    Cost10    Cost30    Revenue100    Revenue400    Revenue200    Revenue300    Revenue400

grazitti_sapna · Accepted Answer

@flying008, the simplest way would be using a tile tool along with a cross tab, this will work dynamically.

I hope this helps!

Thanks!

binu_acs · Accepted Answer

@flying008 one way of doing this, similar to @grazitti_sapna solution