Macro for Excel spreadsheet into Access table
 

How could I take a spreadsheet with thousands of records,
whose last column of cells has comments attached to that
cell?
Example
First Last HEight(comment like 5'8", 5'9", 5'10",etc.)
John Jones 5'10"

I'm trying to pull the comments with each record, possibly
repeating the record with a new choice from the comments
like a different height, say 5'8" for example.
Would this be a macro? and do I create it on the Excel
sheet or in Access? Thank you.