note: cross post

I have no prior experience in writing macros in MS excel. I am willing
to learn.

My situation is:

I have a table with the following columns: patronID and patron#. On a
few ocassions, a few patronIDs have more than one patron#. In that case,
the extra patron # is in an adjoining column in that corresponding row.

here's my howto??

To format the table into only 2 columns- patronID and patron#.
In case of more than one patron # for a particular ID, then, those extra
patron #s are moved from say, column3, into column 2 and the patron ID
value in column 1 is repeated.

Thanks in advance for any help.

Regards,
mickey790