Pivot table help

  • Thread starter Thread starter skoalnreds
  • Start date Start date
S

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.
 
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
 
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 -
Click to expand...

Thanks Roger.
 
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.
 
Back
Top