help me solve using excel please.

8:13 need to know how to solve this using vlookup or other softwares in Excel. there are over 1000 vessels in this data set but you could kindly show me how to solve using excel with just a few of the ones gave and then i can repeat for the whole set. Which carriers has the fastest average average transit time from Shenzen, China to Savannah Ga? How should we think about variability and should it change which carrier we consider the fastest from Shenzen to Savannah? C Car cara SHI, SHONA SHINDA , HINDU Car Cart SEATTLE WASHINGTON SALG ANNA SURGA LANGA SAMANGA LOS ALCA ILANG SURGA WARGA WIREN AWSON 23 STRO THEN WENU Vs C Cars Car VE MADE IN III DI SO NOU THEHE DE ORA HENINO MINH SINO BALCA MENTEN LOUNGE LORE SA G LONA - BINO LOCAL A B D E G Exercise 1 Which carriers has the fastest average transit time from Shenzhen, China to Savannah GA? How should we think about variability and should it change which carrier we consider the fastest from Shenzhen to Savannah? - 3 4 5 6 7 8 19 20 21 22 23 24 25 26 vessel Vessel 1 Vessel 2 Vessel 3 Vessel 4 Vessel 5 Vessel 6 Vessel 7 Vessel 8 Vessel 9 Vessel 10 Vessel 11 Vessel 12 Vessel 13 Vessel 14 Vessel 15 Vessel 16 Vessel 17 Vessel 18 Vessel 19 Vessel 20 Vessel 21 Carrie Carrier 2 Carrier 2 Carrier 2 Carrier 2 Carrier 3 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 3 Carrier 2 Carrier 2 Carrier 4 Carrier 3 Carrier 2 Carrier 3 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 2 Exercise 1 Origin_Name SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA Exercise 2 Exercise 3 Port_of_Discharge_Nam - Departu LOS ANGELES, CA 3-Jul-20 LOS ANGELES, CA 10-Jul-20 LOS ANGELES, CA 10-Jul-20 SAVANNAH, GA 11-Jul-20 SAVANNAH, GA 11-Jul-20 NEW YORK, NY 4-Jul-20 SAVANNAH, GA 18-Jul-20 LOS ANGELES, CA 17-Jul-20 LOS ANGELES, CA 2-Jul-20 LOS ANGELES, CA 2-Jul-20 SEATTLE, WASHINGTON 9-Jul-20 SAVANNAH, GA 4-Jul-20 LOS ANGELES, CA 20-Jul-20 SAVANNAH, GA 18-Jul-20 LOS ANGELES, CA 3-Jul-20 SAVANNAH, GA 4-Jul-20 SAVANNAH, GA 4-Jul-20 LOS ANGELES, CA 3-Jul-20 LOS ANGELES, CA 3-Jul-20 LOS ANGELES, CA 2-Jul-20 SAVANNAH, GA 4-Jul-20 Pivot Table Exercise 4 Arrival 18-Jul-20 26-Jul-20 26-Jul-20 13-Aug-20 7-Aug-20 31-Jul-20 20-Aug-20 1-Aug-20 16-Jul-20 16-Jul-20 25-Jul-20 6-Aug-20 3-Aug-20 14-Aug-20 18-Jul-20 1-Aug-20 1-Aug-20 18-Jul-20 18-Jul-20 16-Jul-20 6-Aug-20 23 24 25 26 27 28 29 30 31 32 34 35 A Vessel 18 Vessel 19 Vessel 20 Vessel 21 Vessel 25 Vessel 27 Vessel 28 Vessel 29 Vessel 30 Vessel 32 Vessel 33 Vessel 35 Vessel 36 Vessel 37 Vessel 40 Vessel 43 Vessel 45 Vessel 48 Vessel 49 Vessel 50 Vessel 51 Vessel 53 Vessel 54 Vessel 55 Vessel 56 Vessel 58 B Carrier 2 Carrier 2 Carrier 3 Carrier 2 Carrier 3 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 2 Carrier 3 Carrier 3 Carrier 3 Carrier 2 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 3 Carrier 3 Carrier 3 Carrier 4 Carrier 2 Carrier 1 Carrier 3 Carrier 2 Exercise 1 SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA Exercise 2 Exercise 3 D E LOS ANGELES, CA 3-Jul-20 LOS ANGELES, CA 3-Jul-20 LOS ANGELES, CA 2-Jul-20 SAVANNAH, GA 4-Jul-20 SEATTLE, WASHINGTON 31-Jul-20 SAVANNAH, GA 25-Jul-20 SAVANNAH, GA 25-Jul-20 SAVANNAH, GA 25-Jul-20 SAVANNAH, GA 25-Jul-20 SAVANNAH, GA 25-Jul-20 LOS ANGELES, CA 9-Jul-20 LOS ANGELES, CA 9-Jul-20 SAVANNAH, GA 4-Jul-20 SAVANNAH, GA 4-Jul-20 NEW YORK, NY 4-Jul-20 SEATTLE, WASHINGTON 2-Jul-20 SEATTLE, WASHINGTON 23-Jul-20 SAVANNAH, GA 4-Jul-20 LOS ANGELES, CA 2-Jul-20 NEW YORK, NY 4-Jul-20 LOS ANGELES, CA 9-Jul-20 LOS ANGELES, CA 10-Jul-20 SAVANNAH, GA 4-Jul-20 LOS ANGELES, CA 4-Jul-20 LOS ANGELES, CA 2-Jul-20 SEATTLE, WASHINGTON 30-Jul-20 Pivot Table Exercise 4 18-Jul-20 18-Jul-20 16-Jul-20 6-Aug-20 17-Aug-20 21-Aug-20 27-Aug-20 27-Aug-20 21-Aug-20 27-Aug-20 23-Jul-20 23-Jul-20 1-Aug-20 6-Aug-20 31-Jul-20 19-Jul-20 9-Aug-20 1-Aug-20 16-Jul-20 31-Jul-20 23-Jul-20 24-Jul-20 6-Aug-20 18-Jul-20 16-Jul-20 15-Aug-20 36 37 38 39 40 41 42 43 45 46 47 48 Ready