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
Solved! Go to Solution.
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