Move multiple rows to column headers

[DGK1981]

Good afternoon all,

I have a data set that i would like to reformat (attached).  I would like to replicate the pivot table in sheet 2 by making row data column data.

Any help would be greatly appreciated.

Many thanks.

David.

[DavidP]

Something like this?

[DGK1981]

Hi David,

Thank you.  I also wanted the Cost Centre along the top too.  Is this possible?

David.

[DavidP · Accepted solution]

The way I created the columns is to add the fields together that you want included, so to include Cost Center, the [Column] field before the CrossTab becomes:

tostring([Cost Center])+'_'+tostring([Year])+'_'+padleft(tostring([Month]),2,'0')

Padleft is used to make sure the months appear in the right order.

[DGK1981]

Perfect, thanks very much.  Handy formula there!