oliveraponte
New Member
- Joined
- Mar 17, 2015
- Messages
- 2
Hello all,
I need your help with the following table which is in a matrix format:
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
To this format:
<tbody>
</tbody>
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I already tried unpivoting some of the columns but I don't get the result I need.
Can you help?
Thanks,
Oliver
I need your help with the following table which is in a matrix format:
Group ID | Group Description | Name 1 | Title 1 | Email 1 | Name 2 | Title 2 | Email 2 | Name 3 | Title 3 | Email 3 |
<tbody>
</tbody>
IT | Information Technology | Oliver Aponte | IT Analyst | oliver@email.com | Juan | Tester | juan@comsdf.com | |||
BU | Business Unit | Daniel Bo | Sponsor | dee@hoasdf.com | ||||||
Sec | Secufity | Mike Cane | Officer | mike@officers.com | Jane Lowe | Officer 2 | jane@thegood.com | Ryan Hug | Commander | ryan@fre.com |
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
To this format:
Group ID | Group Description | Name | Title |
<tbody>
</tbody>
IT | Information Technology | Oliver Aponte | IT Analyst | oliver@email.com |
IT | Information Technology | Juan | Tester | juan@comsdf.com |
BU | Business Unit | Daniel Bo | Sponsor | dee@hoasdf.com |
Sec | Security | Mike Cane | Officer | mike@officers.com |
Sec | Security | Jane Lowe | Officer 2 | jane@thegood.com |
Sec | Security | Ryan Hug | Commander | ryan@fre.com |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I already tried unpivoting some of the columns but I don't get the result I need.
Can you help?
Thanks,
Oliver