can you or anyone help with the macro? thanks!!!

"Pete_UK" wrote:

In the example your 3 starting rows become 10 rows. So, if you have 52,000
of them you are likely to end up needing another sheet (or more) to
accommodate the extra rows produced.

Consequently you will need a macro solution, as a formula could not
automatically insert new sheets. You will need to advise on how you want to
treat the excess rows.

Pete

"susan" wrote in message
...
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!