I have a spreadsheet that includes separate data columns for clients and the bonds that they hold.
In following columns are the dates on which those bonds will pay interest in the future and (i.e. payment date 1, payment date 2, etc.) and the actual amount of interest to be received (i.e. payment amount 1, payment amount 2, etc.)
I would like to create a pivot table that lists the clients and their individual holdings of bonds in columns. Along the top I would like to have a list of all future interest dates and the body of the table would include the amounts to be received on those dates. I have included a simple example below.
Client A June 30 July 31 August 31 September 30 Bond 1 1,000 1,000 Bond 2 1,000 1,000 1,000 1,000 Client B Bond 2 2,000 2,000 2,000 2,000 Bond 3 1,000 1,000
I can easily set-up the columns on the left but I am unable to create a header row that provides the simple picture above. Help!?