Transpose certain columns into rows

[spetkae09]

i have an issue i have rows that contain 2 columns for a phone number and an alternate. The name and user info is all the same but the user might have 2 numbers. 

If column 2 is populated with a second number i would like to duplicate the entire row but have only one phone number field. 

so if :

aaaa 1111
bbbb 2222 6666
cccc 3333
dddd 4444 7777
eeee 5555 8888

then i would like the final result to be something like:

aaaa 1111
bbbb 2222
bbbb 6666
cccc 3333
dddd 4444
dddd 7777
eeee 5555
eeee 8888

[MarqueeCrew · Accepted solution]

@spetkae09

Step #1:  Use a TRANSPOSE tool.

Step #2:  Use a Filter tool

Your output will look like this:

This gets you directionally to where you want to be.  Is the value a Phone Number, could be tested and any non-phone records could be eliminated.  

Cheers,

Mark