I was given a very large database (6500 rows) in excel format. I
need to change the way it is layed out. Column A lists customers,
column B is their phone number(s). Some customers have 2 phone
numbers so they are listed twice. (in 2 rows..1 row for Main phone
number and another with their shipping dept phone number)
I need each customer to be listed on once. (in 1 row) with their phone
numbers in different columns 1 labled MAIN and another labeled
SHIPPING. Maybe a Lookup formula ? Hopefully, the examples below
convey what I
mean

Currently

Cust number type Phone Number
123456 Main 111.222.3333
123456 Shipping 111.222.3334

Desired

Cust Niumber Main Phone Shipping Phone
123456 111.222.3333 111.222.3334


Thanks in advance, Steve