identify and move specific values
 

alright, i am super new to visual basic. i'm using excel 2003.

i have a list of values in column A. they look something like this:

Record 1 of 678

AU: Artist
Modest Mouse
TI: Title
This is a Long Drive for Someone with Nothing to Think About
YR: Year
1996
KW: Keywords
awesome; emo; cool;
interpol
LB: Label
UP Records

and so on for however many records there are.

i want to convert this from one column, to several column. so, artists
would be in one column, titles in the next, keywords in the next, etc. and i
have a couple of problems. every field isn't available for every record.
for example, the artist may be missing from one. or, every field isn't
listed for every record. if there was some uniformity between records, i
could handle this in Excel, but i feel like i need VB for this.

is this too much to ask from a newbie? it's a little overwhelming, and i'm
not sure even where to start!

thanks for any help you can offer!

sara