[dylanw]

I have a large Excel spreadsheet with about six hundred rows of information in 6 columns. Each row is organized like this:

Item A Item B Item C Item D Item E Item F

I need to create a text file with the information from the spreadsheet presented like this:

Item A Item B Item C Item D
Item E
Item F

Does anybody have any idea how to accomplish this easily (i.e. without reformatting each entry by hand)?

Thanks.

[philm]

This is quite easy if you are happy recording a macro. Basically, highlight the top left cell, turn on macro recording (relative references), and then insert two rows below, and cut and paste E and F into their new positions. Highlight the second cell A and then stop the recording.

Go into the macro editing bit and put a 'For i = 1 to 600' line first and 'Next i' at the end. Run the macro and everything should work.

You need to know about a bit of macro stuff to do this, but it will work a charm. Good luck

[dylanw]

Originally posted by philm:
This is quite easy if you are happy recording a macro. Basically, highlight the top left cell, turn on macro recording (relative references), and then insert two rows below, and cut and paste E and F into their new positions. Highlight the second cell A and then stop the recording.

Go into the macro editing bit and put a 'For i = 1 to 600' line first and 'Next i' at the end. Run the macro and everything should work.

You need to know about a bit of macro stuff to do this, but it will work a charm. Good luck

That worked. Thanks!