Macro to copy paste in excel

[Closed]
Report
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
 Trowa -
Dear All

I have a excel sheet in the following style

Project|Lead|manager ---> Header
ABC|XYZ|PQR
DEF|LMN|OPQ

I would like the macro to arrange my data in the following way

Project|ID|Role ---> Header
ABC|XYZ|Lead
ABC|PQR|manager
DEF|LMN|Lead
DEF|OPQ|manager

Your help would really be appreciated

Regards
Ujo

1 reply

Hi Ujo,

Let's say your data has the range A1:C3.

Now create a new sheet and type in the following:

=Sheet1!A1--------ID--------Role
=Sheet1!A2 =Sheet1!B2 =Sheet1!B1
=Sheet1!A2 =Sheet1!C2 =Sheet1!C1
=Sheet1!A3 =Sheet1!B3 =Sheet1!B1
=Sheet1!A3 =Sheet1!C3 =Sheet1!C1

Hope this helps you.
Best regards,
Trowa