Passing values from one column to another in a pivot table

[#1]

can anyone tell me how to pass a value from on column to another, thanks

Martin

[#2]

refer to them as column(1), column(2) ect.

[#3]

Hi there...

Ive tried this but its still working.

I want to pass the value into a "Add Calculated Dimension" in the Dimension tab of a pivot table.

Thanks