Sorting Columns into rows

[mickey790]

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


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Debra Dalgleish]

To reorganize the data, you can use the "unpivot' technique described by
John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm

Then, sort by name, and delete the blank rows at the end of the list.