Needed macro for raw data arrange in colunms

Closed
Atif - Oct 31, 2011 at 12:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 1, 2011 at 11:01 AM
Hello,
i have data in multiple row and transfare in colums, Please help me.


001 GEN V C 00:00:55:02 00:00:58:00 02:01:00:00 02:01:02:23
* FROM CLIP NAME: TEXT
* FROM CLIP IS A GENERATOR

002 AX V C 02:24:45:21 02:27:10:04 02:01:03:23 02:03:28:06
* FROM CLIP NAME: NAWAZ SPEECH ON ZARDARI VO-SOT
* COMMENT:
* PROBLEM WITH EDIT: CLIP HAD NO REEL NAME.

003 GEN V C 00:00:55:00 00:00:58:00 02:03:29:06 02:03:32:06
* FROM CLIP NAME: TEXT
* FROM CLIP IS A GENERATOR

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 1, 2011 at 11:01 AM
Hi Atif,

You mean transpose?
Copy cells, select cell outside first range, right click, paste special and select the option to transpose.

This will turn rows into columns.

Did I understand you correctly?

Best regards,
Trowa
0