Convert Rows to Columns in Excel

Closed

TM - 6 Aug 2009 à 13:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Aug 2009 à 21:25

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

Réponse 1 / 1

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Aug 2009 à 21:25

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