Pivot table help

[skoalnreds]

Hi, I have a vertical list / database that I want to flip
horizontally.

SSN...........Field...........Value
xxxx lastname jones
xxxx firstname mike
xxxx dob 12/31/1958
xxxx empid 58423
xxxy lastname smith
xxxy firstname mary
xxxy dob 04/14/1949
xxxy empid 51474
<etc>

What I want is
SSN LastName FirstName
DOB EmpID
xxxx Jones Mike
12/31/1958 58423
xxxy Smith Mary
04/14/1949 51474
<etc>


When I use the pivot table and I drag the "Value" field onto the
layout grid, the only display choices are calculated items such as
count, stdvar, sum, etc. I just want the actual data with no calcs.
How can I do this? Thank you.

 

[Roger Govier]

Hi

A Pivot Table won't do that.
Set out your required headings in G1:K1
In G2 enter
=INDEX($A:$A,(ROW(A2)-2)*4+2)
In H2 enter
=INDEX($C:$C,(ROW(A2)-2)*4+2+COLUMN(A2)-1)
Copy across through I2:K2

Copy G2:K2 down as far as required.

Copy columns G:K>Paste Special>Values

 

[skoalnreds]

Hi

A Pivot Table won't do that.
Set out your required headings in G1:K1
In G2 enter
=INDEX($A:$A,(ROW(A2)-2)*4+2)
In H2 enter
=INDEX($C:$C,(ROW(A2)-2)*4+2+COLUMN(A2)-1)
Copy across through I2:K2

Copy G2:K2 down as far as required.

Copy columns G:K>Paste Special>Values
--
Regards
Roger Govier







- Show quoted text -

Thanks Roger.

 

[Michael.Tarnowski]

Thanks Roger.

Hi,
if you only want to flip or transpose the data set, use the Excel
TRANSPOSE fctn.: http://www.techonthenet.com/excel/formulas/transpose.php
HTH, have fun
Michael

 

[Michael.Tarnowski]

Thanks Roger.

Hi,
if you only want to flip or transpose the data set, use the Excel
TRANSPOSE fctn.: http://www.techonthenet.com/excel/formulas/transpose.php
HTH, have fun
Michael

 

[Roger Govier]

Hi Michael

Did you try it with the sample data set?
If so, you would realise that doesn't do what the OP asked for.
That data would be strung out across the columns, not in a table as
required.