Convert Rows to Columns in Excel

Closed
TM - Aug 6, 2009 at 01:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 6, 2009 at 09:25 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 6, 2009 at 09:25 PM
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