Rows data to columns

[RanjanThammaiah]

Hi All,

Can some one help me to get the below row data into columns as in the picture. i have tried using the Pivot. its not working for multiple columns for the same total.

Data Sample:1

Pivot in excel:

Data For working:

ID	Name	SL	SSL	Revenue
101	XYZ	Advisory	PAS.	-
101	XYZ	Assurance	Audit	21,657
101	XYZ	Assurance	FAAS	-
101	XYZ	CBS & Elim	ITTS (Elim)	163,993
101	XYZ	CBS & Elim	PAS (Elim)	-
101	XYZ	TAS	Corporate Finance	75
101	XYZ	TAS	ITTS (in TAS)	-                       163,993
101	XYZ	TAS	Strategy and Operations	-
101	XYZ	TAS	TD - Transaction Diligence	12,806
101	XYZ	Tax	BTS	11,227
101	XYZ	Tax	GCR	11,904
101	XYZ	Tax	Indirect	13,013
101	XYZ	Tax	International Tax Transaction Services	-                       163,993
101	XYZ	Tax	PAS	-
1011	ABC	Advisory	PAS.	12,506
1011	ABC	CBS & Elim	ITTS (Elim)	-                            1,998
1011	ABC	CBS & Elim	PAS (Elim)	-                          12,506
1011	ABC	TAS	ITTS (in TAS)	1,998
1011	ABC	Tax	GCR	36,497
1011	ABC	Tax	Indirect	4,477
1011	ABC	Tax	International Tax Transaction Services	1,998
1011	ABC	Tax	PAS	12,506

[v-kelly-msft]

Hi @RanjanThammaiah ，

Matrix is a best choice as suggested by @mussaenda ,have you tried it?Is your issue solved?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mussaenda]

Hi @RanjanThammaiah,

you can use matrix table to meet your requirements

[vivran22]

Hello @RanjanThammaiah 

Not sure what you are trying to achieve. Are you trying to transform the data table into the displayed pivot table structure (with two-row headers, minus the total)?

Regards,
Vivek

https://www.vivran.in/