Multiple Consolidation Pivot table

[sythong]

I tried to generate a pivot table based on the following
data but it does not come up with what I had in mind:-

A B C D E F
Code Ac-Debit Amt-Debit Code Ac-Credit Amt-Credit
DL1001 ABC 100 GL 1001 Sale 100

When I use multiple consol:
$B$2:$C$2 and $E$2:$F$2 I have pivot table

ABC 100
Sale 100

Good enough, but I when I try
$A$2:$C$2 and $D$2:$F$2 to get this

DL 1001 ABC 100
GL 1001 Sale 100
it does not work

Appreciate anyone can advise whether this can be done
Thanks

 

[Debra Dalgleish]

In a pivot table created from multiple consolidation ranges, only the
first field is displayed in the row area, so you can't achieve the
layout shown in your second example.

You could create a pivot table from all the data, with multiple fields
in the row area, and Amt-Debit and Amt-Credit in the data area.