Hi there,
I'll go straight to the point since this is breaking my head and the only way I am seeing to do this is one by one, what would be really time consuming.
Here's my situation:
I have an excel table with 65536 rows and 5 columns. The objective is to have one with 99 columns and around 23000 rows.
The tables is like this:
User Question Answer Code Name
5 1 2 AB xyz
5 2 4 AB xyz
5 3 1 AB xyz
5 4 5 AB xyz
7 1 1 AB xyz
7 2 3 AB xyz
7 3 5 AB xyz
7 4 4 AB xyz
What i need is that the 'User' column is grouped into one row (each user one row) and divided into columns (the questions). Looking like this:
User 1 2 3 4 Code Name
5 2 4 1 5 AB xyz
7 1 3 5 4 AB xyz
I'd appreciate a lot your help, it would save me a lot of time.
Thanks in advance
G.
I'll go straight to the point since this is breaking my head and the only way I am seeing to do this is one by one, what would be really time consuming.
Here's my situation:
I have an excel table with 65536 rows and 5 columns. The objective is to have one with 99 columns and around 23000 rows.
The tables is like this:
User Question Answer Code Name
5 1 2 AB xyz
5 2 4 AB xyz
5 3 1 AB xyz
5 4 5 AB xyz
7 1 1 AB xyz
7 2 3 AB xyz
7 3 5 AB xyz
7 4 4 AB xyz
What i need is that the 'User' column is grouped into one row (each user one row) and divided into columns (the questions). Looking like this:
User 1 2 3 4 Code Name
5 2 4 1 5 AB xyz
7 1 3 5 4 AB xyz
I'd appreciate a lot your help, it would save me a lot of time.
Thanks in advance
G.