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