Convert Rows to Columns in Excel [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
I just need to create a simple macro or VB Script to convert Rows of data into Columns where the break is a blank line between rows.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
why do you want vbscript/ just copy and pastspecial-transpose.
if the data sheet is more complicated give a sample sheet.
see help for transpose
7
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!