Original data looks like this in Columns:

Name Dept. Location Ext.
XXX 101,102,103,104 111 7777
YYY 106,107,108 222 8888
ZZZ 210,220,230 333 9999

I want the data to look like this:

Name Dept. Location Ext.
XXX 101 111 7777
XXX 102 111 7777
XXX 103 111 7777
XXX 104 111 7777
YYY 106 222 8888
YYY 107 222 8888
YYY 108 222 8888
ZZZ 210 333 9999
ZZZ 220 333 9999
ZZZ 230 333 9999


I used the "Text to Columns" function to separate the "Dept" into multiple
columns. I want to transpose the "Dept" column to rows following the
original row, then copy the rest of the information from the original row to
the transposed rows. Is this possible?

I have 2 excel tabs with 52,000 records in each right now so I can't imagine
doing this manually. I am using Excel 2003.

Please HELP!!!!
Thanks!