I have survey data from a database export in 3 columns. Each question is one
a seperate line with the answer and the person who did the survey, so it
looks like
Question User Answer
q1 user1 a1
q2 user1 a2
q1 user2 a3
q2 user2 a4

I want it displayed where the rows are combined with the question on top so
you have

User q1 q2
user1 a1 a2
user2 a3 a4

Pivot tables would work except the data field will not display the actual
values. Cut & Paste Transposing would only work with alot work. Since this
has to be done by an end user exporting to a database and then doing a quick
select is not an option.

Can someone please point me to a solution or is there some excel related
terms I should be using in my searches?

Thanks

Pl stop repeat posting. Your query came through 1st time you posted. Ignore
the spurious sys msg that it didn't (there's a current technical fault with
MS' web interface, yet unresolved)

Here's the response in your earlier thread:

One way to get there
Source data as posted assumed in A1:C5, data from row2 down
In F1 across a q1, q2
In E2 down a user1, user2
Put in F2, normal ENTER:
=INDEX($C$2:$C$5,MATCH(1,INDEX(($A$2:$A$5=F$1)*($B $2:$B$5=$E2),),0))
Copy F2 across/fill down to G3 to populate. Adapt to suit ranges to suit.

If it helped, high-five it by pressing the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Will" wrote:
I have survey data from a database export in 3 columns. Each question is one
a seperate line with the answer and the person who did the survey, so it
looks like
Question User Answer
q1 user1 a1
q2 user1 a2
q1 user2 a3
q2 user2 a4

I want it displayed where the rows are combined with the question on top so
you have

User q1 q2
user1 a1 a2
user2 a3 a4

Pivot tables would work except the data field will not display the actual
values. Cut & Paste Transposing would only work with alot work. Since this
has to be done by an end user exporting to a database and then doing a quick
select is not an option.

Can someone please point me to a solution or is there some excel related
terms I should be using in my searches?

Thanks