Creating Grids From A Pivot Table

[YankDownUnder]

I'm trying to create a spreadsheet that shows the distance between locations with common items.

I'm creating a pivot table showing locations by item, but I need to duplicate (transpose) the row labels as column headers to create a grid to put my distance formulas in.

I've manually entered some sample headers for example.

Thanks in advance, guru's!

[dohvakin123]

in B5:

=SQRT((VLOOKUP($A5,Loc!$A:$B,2,0)-VLOOKUP(Distance!B$4,Loc!$A:$B,2,0))^2 + (VLOOKUP($A5,Loc!$A:$C,3,0)-VLOOKUP(B$4,Loc!$A:$C,3,0))^2)

then drag/copy it into the rest of the empty cells

[YankDownUnder]

in B5:

=SQRT((VLOOKUP($A5,Loc!$A:$B,2,0)-VLOOKUP(Distance!B$4,Loc!$A:$B,2,0))^2 + (VLOOKUP($A5,Loc!$A:$C,3,0)-VLOOKUP(B$4,Loc!$A:$C,3,0))^2)

then drag/copy it into the rest of the empty cells

Sorry, I probably should have said I'm looking for a macro that will do this when I click a "refresh" button I put in that will also refresh the pivot table (I can handle that bit).