Hi,

I apologise if this is a really simple request but I just can't get my head around the best way to get some data into the format that I want.

I've run a pivot table report which has given me our reference and then the corresponding client’s details for that reference.

The pivot table has however given me the data all within the one column. E.g. in column A row 1 we have our reference and in column A row 2 we have the clients name.

Column A
1111111
Client 1 Name
22222222
Client 2 Name
3333333
Client 3 Name


Is there any way to take the clients name and put them into column B so the data would then look like this;

Column A Column B

1111111 Client 1 Name
2222222 Client 2 Name
3333333 Client 3 Name


I've originally tried to swap the clients name data into the column row but the pivot table says it can't do this as there are too many fields.

Any help would be most appreciated.