I have a spreadsheet of data I exported from a Loutus Notes folder that
unfortunately I can only get in this format:

First: Fred
Last: Flintstone
Title: Controller
First: Betty
Last: Rubble
Title: Analyst
First: Donald
Last: Duck
Title: VP


Is there a function I could use to fill in some kind of unique identifier in
a column so I can turn these into records with a pivot table?
Like this:


A First: Fred
A Last: Flintstone
A Title: Controller
B First: Betty
B Last: Rubble
B Title: Analyst
C First: Donald
C Last: Duck
C Title: VP


Or any other ideas?


I want to end up with:

First Last Title

Fred Flintstone Controller
Betty Rubble Analyst
Donald Duck VP



Thanks for any ideas and help!

Holly