Pivot table - combining servel columns with the same data (text)

[srw1983]

Hi folks,

I've got a slight problem with my Pivot tables in Excel 2007.

I'd like to make an analysis about several Banks. When a bond gets issued, there are several banks organized as a consortium. I.e. I have Lead1, Lead2, and so on.
If I put Lead1 in the pivot table as a column and the letter of credit as row, it works fine. But when I put Lead2, Lead3... in their, its a mess.

<TABLE cellSpacing=0 cellPadding=2 width=323 border=0><TBODY><TR><TD width="25%" bgColor=#ff0000 height=15>Lead 1

​

</TD><TD width="25%" bgColor=#ff0000 height=15>Lead 2

​

</TD><TD width="25%" bgColor=#ff0000 height=15>Lead 3

​

</TD><TD width="25%" bgColor=#ff0000 height=15>Lead 4

​

</TD></TR><TR><TD width="25%" height=15>SG

</TD><TD width="25%" height=15>

</TD><TD width="25%" height=15>

</TD><TD width="25%" height=15>

​

</TD></TR><TR><TD width="25%" height=15>BNP

​

</TD><TD width="25%" height=15>CMZ

​

</TD><TD width="25%" height=15>Danske

​

</TD><TD width="25%" height=15>Lloyds

​

</TD></TR><TR><TD width="25%" height=15>CAI

​

</TD><TD width="25%" height=15>LBBW

​

</TD><TD width="25%" height=15>SG

</TD><TD width="25%" height=15>

​

</TD></TR><TR><TD width="25%" height=15>LBBW

​

</TD><TD width="25%" height=15>SG

</TD><TD width="25%" height=15>

</TD><TD width="25%" height=15>

</TD></TR></TBODY></TABLE>​

I hope you can help me.

 

[Fazza]

Hi,

It would help if you can post two images - one of the sample data and one of the expected results.

Thanks, F

 

[srw1983]

Sorry about that, there you go. If u need further information, let me know!

Thx

Sum of LT Cr Country
Lead 1 France Germany Spain Sweden
LBBW 2849 292 250
CMZ 1071
BNP 548 417

 

[Fazza]

Hi,

Can you start afresh, please?

It would help if you can post two images - one of the sample data and one of the expected results.

Thanks, F

 

[srw1983]

I tried to copy the tables from Word into this forum, but as you can see it didnt copy the format.

I just tried several times, but no success.

 

[srw1983]

I really feel stupid, I posted a copy of my data and I wanted to copy a part of the Pivot table, but no its just pasting the no and text in without the nice format I made

 

[srw1983]

Word Doc:

http://www.box.net/shared/fohhdp0tzt