Pivot comes in single column. How to convert them in 2 different columns

[baljeetgrover]

I was creating excel file for my online orders. Sometimes buyers buy multiple items in same order. So we receive report as repeated order ids (in rows) with different product names. So when i use pivot it gives multiple products in the same column. So we can't use lookup option when we have multiple options with only 1 heading. So how can i create one more column in pivot so my data will come as like in column 1- Order Id.. in Column 2-Product-1.... in column 3-product 2..

I have attached excel file link as well.https://www.dropbox.com/s/51l45xbk20tgo8u/Sample.xlsx?dl=0

Thanx..

 

[Jerry Sullivan]

It's not clear to me from your description and your example file whether you want each column to represent a specific Product (M001), or the first, second, third,... product in an order regardless of the Product number.

Assuming it's the former, if you place the Product field in the Columns area of the PivotTable, you'll get something like this.

Excel 2016
	A	B	C	D	E	F	G
1
2
3	Sum of Qty	Column Labels
4	Row Labels	M001	M002	M003	M005	M006	Grand Total
5	402-8453939-0119544	1					1
6	404-5356786-2996346		2	3			5
7	407-2358867-6459516	1					1
8	408-3638008-7009130				2	1	3
9	Grand Total	2	2	3	2	1	10
10
11
Sheet1

Is that what you are wanting?