missminimac
New Member
- Joined
- Sep 6, 2011
- Messages
- 5
Greetings from Colorado,
Working in Excel 2010.
Is there a transpose solution to create the desire table below?
Current table:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Desire table:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks so much for your help!
Snowed in co all day yesterday Happy May
missminimac
Working in Excel 2010.
Is there a transpose solution to create the desire table below?
Current table:
code | job | survey ID | match |
12345 | Accountant | PHRA-GSK12 | F395-5 |
12345 | Accountant | PHRA-GSK12 | 3303 |
12345 | Accountant | PHRA-GSK12 | Z010-6 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Desire table:
code | job | Survey ID + match 1 | Survey ID + match 2 | Survey ID + match 3 |
12345 | Accountant | PHRA-GSK12 F395-5 | PHRA-GSK12 3303 | PHRA-GSK12 Z010-6 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks so much for your help!
Snowed in co all day yesterday Happy May
missminimac