brendanolear
Active Member
- Joined
- Apr 26, 2008
- Messages
- 366
Hi seeking guidance on the following:
I have a table of data with staff names in Column A and Performance numbers in same row thereafter.
What I am trying to do is convert the top table in my example to the bottom table but do not know how to; using either transpose data or vlookup/hlookup etc.
I can do it with lots of cutting and pasting but there must be a simple way - please.
<colgroup><col width="64" style="width:48pt" span="5"> </colgroup><tbody>
</tbody>
I have a table of data with staff names in Column A and Performance numbers in same row thereafter.
What I am trying to do is convert the top table in my example to the bottom table but do not know how to; using either transpose data or vlookup/hlookup etc.
I can do it with lots of cutting and pasting but there must be a simple way - please.
Name | P1 | P2 | P3 | P4 |
A.Smith | 50 | 60 | 42 | 35 |
C.Jones | 25 | 12 | 16 | 18 |
N.Brown | 45 | 12 | 16 | 14 |
A.Smith | P1 | 50 | ||
A.Smith | P2 | 60 | ||
A.Smith | P3 | 42 | ||
A.Smith | P4 | 35 | ||
C.Jones | P1 | 25 | ||
C.Jones | P2 | 12 | ||
C.Jones | P3 | 16 | ||
C.Jones | P4 | 18 | ||
N.Brown | P1 | 45 | ||
N.Brown | P2 | 12 | ||
N.Brown | P3 | 16 | ||
N.Brown | P4 | 14 |
<colgroup><col width="64" style="width:48pt" span="5"> </colgroup><tbody>
</tbody>