Search : in
By :

Convert Rows to Columns in Excel

Last answer on Aug 7, 2009 2:25:08 am BST TM, on Aug 6, 2009 6:20:44 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Convert Rows to Columns in Excel » in :
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...

1

 venkat1926, on Aug 7, 2009 2:25:08 am BST
  • +3

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

Reply to venkat1926