HEllo,

I have this case Study that would like some help in excel on it. On page #1, is how I received the data where all the phones types ( Mobile, land line, and VOIP) are in the same column. I tried to filter but it wasn't helpful because there are multiple mobile number, land line and VOIP. On page #2, I show a sample that would work very well where the phone types will be separated based on type of the phone. My question is HOW can you make it from Page #1 set up to Page #2 set up! Please try to solve this issue in excel because there are many records in the spreadsheet and can't do it one by one! Please show the steps and formula that you use in excel. Thank you !

Font Alignment Number Styles Editing PHONE1_PHONE PHONE1_PHONE PHONE2_PHONE PHONE2_PHONE - PHONE3_PHONE PHONE3_PHONE-PHONE3_PHONE 6199208107 Mobile 8584559476 Land Line 8582321838 Mobile 6192773476 Mobile 6195964996 VoIP 3148631437 Mobile 6198180265 Mobile 3145601958 Mobile 3145787987 Mobile 8585710134 Land Line INPUT_ADDRESS_CITY San Diego San Diego Hot Springs Santee St Louis Rancho Santa Fe Chula Vista San Diego San Diego South Lake Tahoe La Mesa La Mesa Spring Valley La Mesa Santee Chula Vista Chula Vista San Diego Poway San Diego Lemon Grove 5303184136 Mobile 8059144485 Mobile 6195189418 Mobile 6194601088 Land Line 6197502224 Mobile 6194483881 VoIP 6194220665 Land Line 5305441285 Land Line 2405958898 Mobile 6197418868 VoIP 8584843388 Land Line 6193033738 Land Line 5303184134 Mobile 8053882617 Land Line 6195183405 Mobile 6195041089 Mobile 6194259865 Land Line 6199902170 Mobil 6192811637 Land Line 6198474551 Mobile 6195344052 Mobile F Sort & Filters Editing . Desire BIU 33 A Merge & Center - Format Painter $ % Conditional Format , Cell Insert Delete Format Formatting as Table Styles Clear Clipboard Font Alignment Number Styles Cells Y21 fx ST AB INPUT_ADDRESS_CITY Mobile1_PHONE Land Line1_PHONE_TYPE VOIP1_PHONE_TYPE Mobile2_PHONE Land Line2_PHONE_TYP VOIP3_PHONE San Diego 6199208107 San Diego 8584559476 8582321838 6192773476 Hot Springs Santee 6195964996 6198180265 St Louis 3148631437 3145601958 Rancho Santa Fe Chula Vista 5303184136 San Diego 8585710134 San Diego 5303184136 South Lake Tahoe 5303184136 5303184136 5305441285 La Mesa 8059144485 2405958898 La Mesa 6195189418 6197418868 Spring Valley 6194601088 8584843388 La Mesa 6197502224 6193033738 Santee 6194483881 6194483881 Chula Vista 6194220665 6194259865 set up Font Alignment Number Styles Editing PHONE1_PHONE PHONE1_PHONE PHONE2_PHONE PHONE2_PHONE - PHONE3_PHONE PHONE3_PHONE-PHONE3_PHONE 6199208107 Mobile 8584559476 Land Line 8582321838 Mobile 6192773476 Mobile 6195964996 VoIP 3148631437 Mobile 6198180265 Mobile 3145601958 Mobile 3145787987 Mobile 8585710134 Land Line INPUT_ADDRESS_CITY San Diego San Diego Hot Springs Santee St Louis Rancho Santa Fe Chula Vista San Diego San Diego South Lake Tahoe La Mesa La Mesa Spring Valley La Mesa Santee Chula Vista Chula Vista San Diego Poway San Diego Lemon Grove 5303184136 Mobile 8059144485 Mobile 6195189418 Mobile 6194601088 Land Line 6197502224 Mobile 6194483881 VoIP 6194220665 Land Line 5305441285 Land Line 2405958898 Mobile 6197418868 VoIP 8584843388 Land Line 6193033738 Land Line 5303184134 Mobile 8053882617 Land Line 6195183405 Mobile 6195041089 Mobile 6194259865 Land Line 6199902170 Mobil 6192811637 Land Line 6198474551 Mobile 6195344052 Mobile F Sort & Filters Editing . Desire BIU 33 A Merge & Center - Format Painter $ % Conditional Format , Cell Insert Delete Format Formatting as Table Styles Clear Clipboard Font Alignment Number Styles Cells Y21 fx ST AB INPUT_ADDRESS_CITY Mobile1_PHONE Land Line1_PHONE_TYPE VOIP1_PHONE_TYPE Mobile2_PHONE Land Line2_PHONE_TYP VOIP3_PHONE San Diego 6199208107 San Diego 8584559476 8582321838 6192773476 Hot Springs Santee 6195964996 6198180265 St Louis 3148631437 3145601958 Rancho Santa Fe Chula Vista 5303184136 San Diego 8585710134 San Diego 5303184136 South Lake Tahoe 5303184136 5303184136 5305441285 La Mesa 8059144485 2405958898 La Mesa 6195189418 6197418868 Spring Valley 6194601088 8584843388 La Mesa 6197502224 6193033738 Santee 6194483881 6194483881 Chula Vista 6194220665 6194259865 set up