Sep 16 2022 08:59 AM
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.
Attached a link to what i mean You can see that there is a mix of landline phone numbers and mobile in each column. I want to find a way to make it only mobile and only landline in its own column
https://ibb.co/k41dp76ibb.co/k41dp76
Sep 16 2022 09:53 AM
Sep 16 2022 04:15 PM
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.
Sep 16 2022 05:15 PM - edited Sep 16 2022 05:19 PM
@Benbee250 The link to your original file is broken, could you please re-post?
Okay I see the link was pasted twice and I can now see the picture but it would be helpful to have some data to work with instead. I think it's an easy solution but need to test.
Sep 17 2022 12:10 PM
Sep 17 2022 12:17 PM
So, This is the original. this link is what my file looks like https://ibb.co/YfkrBcN.
I would like to have the landlines and mobile in order but in the same row if that makes sense.
So like Landline 1| Landline 2... Mobile 1| Mobile 2.... l to look like this https://ibb.co/NT6vDzG .
If needed send me your email i can send you the file to test.
Sep 17 2022 05:14 PM