Forum Discussion
ORGANIZE FILE
Hello, I have an excel file with 2k names/phone numbers and addresses. I need to organize the file to make sure the phone numbers are in one column all landline phones and in the other all mobile. ...
what i mean is i want it to be organized like this sample attached. https://ibb.co/NT6vDzG.
want all the landlines in one column and mobiles.
as dexter noted, it would be easier if we had a sample sheet (personal/confidential info stripped).
but as I noted above a simple IF statement could work. In each of your NEW "Landline" columns you have IF(S2="Land Line",R2,"") where S2 and R2 which are for "Phone0" to the columns for "Phone1" ... and the same thing for new "Mobile" columns except ="Mobile"
but as I noted above a simple IF statement could work. In each of your NEW "Landline" columns you have IF(S2="Land Line",R2,"") where S2 and R2 which are for "Phone0" to the columns for "Phone1" ... and the same thing for new "Mobile" columns except ="Mobile"