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

A B C D
E F G
1 Question User Answer User
Q1 Q2
2 q1 User1 A1 User1
A1 A2
3 q2 User1 A2 User2 A3 A4
4 q1 User2 A3 User3
A5 A6
5 q2 User2 A4 User4 A7 A8


In E2: =Offset($B$2,(Row()-2)*2,0)
In F2: =Offset($C$2,(Row()-2)*2,0)
In G2: =Offset($D$2,(Row()-2)*2,0)

JB
http://boisgontierjacques.free.fr/



On 11 fév, 15:12, 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