Merged Cells

I have imported data into Excel. The left-hand column has merged cells
containing a reference number. The remaining columns contain varying records
associated with the reference number, a one to many ratio. I need to display
the worksheet so that the appropriate reference number is displayed in the
left-hand column for each of the records in the worksheet. There are hundreds
of reference numbers. Is there an automated way to do this besides unmerging
each section and copying the reference number into the now unmerged cells?

Thank you.