Unpivot table

[oliveraponte]

Hello all,

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

Email

<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

 

[cyrilbrd]

...
I already tried unpivoting some of the columns but I don't get the result I need.
...

Hi, based on your query it is assumed that table one is a pivot table right?
Care to explain how to proceeded to 'unpivot'?
Please confirm that you wish to get the raw data from an existing pivot table.

 

[oliveraponte]

Hi, based on your query it is assumed that table one is a pivot table right?
Care to explain how to proceeded to 'unpivot'?
Please confirm that you wish to get the raw data from an existing pivot table.

Hello,

In fact, the table 1 is NOT a pivot table. It is just how I have the data now: one single row for the records of all the emails and titles and names. So I wish to convert it to the format in table 2.

Thanks for your help,

Oliver

 

[SpillerBD]

Check out the macro in this "old" thread.
http://www.mrexcel.com/forum/excel-questions/399106-transform-table-into-list-how-unpivot-table.html