I have a range of information exported from another app that I need to reorganize.
In each row there are between 1 and 4 phone numbers in columns D-G with various contact information in columns A-C. I need the information arranged so that there is only one phone number per row.
So if there are are phone numbers in columns D, E, and G with a blank in F, I need to have 3 rows, each with only one phone number and all the same contact information from columns A-C.
I've taken some VB but this is beyond me. Any help would be greatly appreciated!