Convert Rows to Columns in Excel

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
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