Join multiple rows into columns
 

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

Join multiple rows into columns
 

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.
--
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

Join multiple rows into columns
 

try this

Cell E2 - down user1,user2...
Cell F1 - across Q1, Q2,Q3..
in Cell F2 put this formula and drag it down & across

=LOOKUP($E2&F$1,$B$2:$B$5&$A$2:$A$5,$C$2:$C$5)



"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

Join multiple rows into columns
 

Thanks, I think with some modifing that should be able to do it.

Sorry about the duplication posts, I was getting time outs errors so I was
reposting in hopes the local network would start working again.

Join multiple rows into columns
 

Welcome, but please go back to the responses and press the YES buttons there,
won't you? Thanks
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Will" wrote:
Thanks, I think with some modifing that should be able to do it.

Sorry about the duplication posts, I was getting time outs errors so I was
reposting in hopes the local network would start working again.