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