Hi, I am exporting from a database as a csv which provides the following ID,NAME,RATING
<tbody>
</tbody>
I need to transform this into the following
<tbody>
</tbody>
As you can see it has changed the ID from the horizontal to the vertical,
Filled in the missing ID numbers, in this case 6,7,and 8
it has changed the NAME from individual instances to a single unique instance for each
it has assigned the RATING under the ID for each NAME
My only progress towards the change so far is using paste-special with transpose to change the values from a horizontal to vertical layout.
Onward I am unsure and assume it would be quite VBA heavy?
ID1 | BEN | 1 |
ID2 | BEN | 1 |
ID3 | BEN | 2 |
ID4 | BEN | 3 |
ID5 | JAMES | 1 |
ID1 | SAM | 1 |
ID4 | SAM | 2 |
ID2 | DAN | 1 |
ID9 | DAN | 2 |
ID10 | DAN | 2 |
<tbody>
</tbody>
I need to transform this into the following
ID1 | ID2 | ID3 | ID4 | ID5 | ID6 | ID7 | ID8 | ID9 | ID10 | |
BEN | 1 | 1 | 2 | 3 | ||||||
JAMES | 1 | |||||||||
SAM | 1 | 2 | ||||||||
DAN | 1 | 2 | 2 |
<tbody>
</tbody>
As you can see it has changed the ID from the horizontal to the vertical,
Filled in the missing ID numbers, in this case 6,7,and 8
it has changed the NAME from individual instances to a single unique instance for each
it has assigned the RATING under the ID for each NAME
My only progress towards the change so far is using paste-special with transpose to change the values from a horizontal to vertical layout.
Onward I am unsure and assume it would be quite VBA heavy?