Join multiple rows into columns

W

Will

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
 
M

Max

One way to get there
Source data as posted assumed in A1:C5, data from row2 down
In F1 across are: q1, q2
In E2 down are: 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
 
M

muddan madhu

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)
 
W

Will

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top