Related:
- Macro to copy paste in excel
- Excel - A macro to copy/paste a selected range - How-To - Excel
- Excel macro copy and paste data from one workbook to another - How-To - Excel
- Macro to take screenshot and paste in excel - How-To - Excel
- Excel macro for copy & paste selected range ✓ - Forum - Programming
- Macro to insert picture in excel - How-To - Excel
1 reply
Trowa
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
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
Subscribe To Our Newsletter!
