Col2 into col1

[karyoker]

Karaoke hosters generate a data base from the actual track zip files. The result is a songlist.mdb which consists of a table which contains an artist col and a song col.. It has other cols which are deleted.. This table has about 13,000 tracks.

I am trying to use design view for printing books. I need a macro or method to do this...
artist song
Artist1 Song1
Artist1 Song2
Artist1 Song3
Artist2 Song1

into this

Artist1
Song1
Song2
Song3
Artist2
Song1

Where the artist is only listed once and lists that artists songs below....

 

[Lilliabeth]

You didn't say what you ultimately plan to do with the output.

If you just need an attractive printout...

Use the report wizard. Group by Artist.

 

[karyoker]

Thanks it was just a matter of putting the artists into the header section and songs in detail...