Combine 2 column in pivot table

[john5599]

I have an excel sheet as given below. I want to name and address column in pivot table. If it is possible

Sheet1[TABLE="class: html-maker-worksheet"]<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[/TR]</thead><tbody>[TR]
[TH]1[/TH]
[TD="align: center"]INVOIVCE
NO[/TD]
[TD="align: center"]
INVOICE
DATE[/TD]
[TD="align: center"]CHELLAN
NO[/TD]
[TD="align: center"]PARTY NAME[/TD]
[TD="align: center"]ADDRESS[/TD]
[TD="align: center"]ITEM NAME[/TD]
[TD="align: center"]ITEM
CODE[/TD]
[TD="align: center"]HSN[/TD]
[TD="align: center"]QTY[/TD]
[TD="align: center"]TYPE[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]5622218065[/TD]
[TD]15/11/18[/TD]
[TD][/TD]
[TD]Samsung[/TD]
[TD]Mussaffa[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]24[/TD]
[TD]PURCHASE[/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]18138811255[/TD]
[TD][/TD]
[TD][/TD]
[TD]Honeywell[/TD]
[TD]Burdubai[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]1[/TD]
[TD]SALES RETURN[/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]5322121331[/TD]
[TD]12/12/18[/TD]
[TD]CH.1723[/TD]
[TD]ABC TRADERS[/TD]
[TD]Kalifa[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]1[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD]4533588321[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun & Sand[/TD]
[TD]Mrina[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]4[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD]3365655881[/TD]
[TD]21/12/18[/TD]
[TD][/TD]
[TD]Maxwell[/TD]
[TD]Port Sea[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]1[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD]1232558841[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jumbo Traders[/TD]
[TD]Khaldiya[/TD]
[TD]TRIM CLIP ON LED PANEL 6W 6500K[/TD]
[TD]LHEAABP7IL1W006[/TD]
[TD]9405[/TD]
[TD="align: right"]1[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD]3365458522[/TD]
[TD]15/11/18[/TD]
[TD][/TD]
[TD]Rotona[/TD]
[TD]Sharja[/TD]
[TD]TRIM CLIP ON LED PANEL 12W 6500K[/TD]
[TD]LHEAABP7IL1W012[/TD]
[TD]9405[/TD]
[TD="align: right"]24[/TD]
[TD]PURCHASE[/TD]
[/TR]</tbody>[/TABLE]
Excel 2007

Excel Workbook
	A	B	C	D	E
3	Sum of Field1	Column Labels
4	Row Labels	PURCHASE	SALE	SALES RETURN	Grand Total
5	ABC TRADERS	0	1	0	1
6	Honeywell	0	0	1	1
7	Jumbo Traders	0	1	0	1
8	Maxwell	0	1	0	1
9	Rotona	24	0	0	24
10	Samsung	24	0	0	24
11	Sun & Sand	0	4	0	4
12	Grand Total	48	7	1	56
Sheet4

Excel 2007




I want address column in pivot table column b. how can i do it in excel 2007

 

[Misca]

Just drag the Address field next to the Name field.

If the Address appears on the column A change the Report Layout (on the Design tab of the PivotTable Tools) to Tabular Form.