How to easy transpose the table to want form?

[flying008]

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

Input			Output
Type	Value		Profit	Cost	Revenue
Profit	10		10	40	100
Profit	20		20	20	400
Profit	30		30	30	200
Profit	20		20	10	300
Cost	40			30	400
Cost	20
Cost	30
Cost	10
Cost	30
Revenue	100
Revenue	400
Revenue	200
Revenue	300
Revenue	400

[grazitti_sapna · Accepted solution]

@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 solution]

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

[flying008]

Hi, @grazitti_sapna @binu_acs 

Thank you both ! there are perfect solutions ! 

[grazitti_sapna]

@flying008, glad it worked for you.

Thanks!