rows data and text combine question

[lilyyangadsk]

May i ask how to formula same order # multiple lines into one line to sum total billing, but also aggregate product class column text with comma separated values in a single cell. attached is sample data report. thank you very much.

Invoice Date	Order #	product class	Total Billing
May-10	101	AEC	10
May-10	101	MFG	20
May-10	101	AUTOCAD	15
Apr-05	155	Autocad LT	20
Apr-05	155	Autocad	30
May-06	177	Ravit	10
May-03	178	MFG	40

[grazitti_sapna · Accepted solution]

@lilyyangadsk , this can be achieved using summarize tool.

Thanks!

[Qiu · Accepted solution]

@lilyyangadsk 

Just for a change, the Combination of Transpose and Cross Tab can be also achieve the same.