I have a spreadsheet with songtitles associated to a CD catlaogue numbe
that is laid out like this:

[image: http://www.firstfoot.com/Library/images/excelsheet.jpg]

To get it into a format to impert it into a database, I need to make i
look like this:

[image: http://www.firstfoot.com/Library/ima...celsheet2.jpg]

Where the song title is horizontally aligned with each catalogu
number.

But I just can't suss the macro to do it.

My head is sore from banging it on the screen. Any ideas

--
Message posted from http://www.ExcelForum.com