I have worksheets with column A showing account number, with multiple phone
numbers associated to this account in a comment bubble, coulumn B showing the
carrier name.
What I am trying to do is to get these data into 3 columns, one row for each
phone number depending on how many records in each comment, also with
repeating account and carrier description for example:

Account number phone number carrier
12345 123-123-1234 AT&T
12345 123-234-2345 AT&T
12345 234-334-3345 AT&T

I had tried copy phone nubmers from comment to column C, then do Text to
Column, and TRANSPOSE but this will take a year for me to finishe all the
worksheets. I am hoping there are some easier way to do this...

Help !
And thanks in advance!!