Question
1. Split 1: Use the Text-to- Columns menu to split the Delivery Location column. Select 'comma' as the delimiter. Delivery Location Ace Foods, Omaha NE
1. Split 1: Use the Text-to- Columns menu to split the "Delivery Location" column. Select 'comma' as the delimiter.
Delivery Location Ace Foods, Omaha NE Millers Foods, Tulsa OK Ace Foods, Shrevport LA Arch Foods, St. Louis MO Food Warehouse, Chicago IL Shipping Plant, Chicago IL River Front Foods, La Crosse WI Dakota Brothers, Chamberlain SD Mountain Foods, Greely CO Ace Foods, Omaha NE Shipping Plant, Chicago IL Taylor Foods, Dayton OH Ohio Foods, Cleveland OH Shipping Plant, Chicago IL Shipping Plant, Chicago IL Overland Foods, Overland Park KS OK Foods, Oklahoma City, OK Ace Foods, Little Rock AR Arch Foods, St. Louis MO Food Warehouse, Chicago IL Shipping Plant, Chicago IL
2. Split 2: Use the Left and Right function to split the "Starting location" column
Starting Location Shipping Plant, Chicago IL Warehouse, Lincoln NE Dispatch Center, Tulsa OK Dispatch Center, Shrevport, LA Shipping Plant, St. Louis MO Shipping Plant, Chicago IL Shipping Plant, Chicago IL Distribution Center, Winona MN Central Warehouse, Chamberlain SD Warehouse, Greely CO Warehouse, Lincoln NE Shipping Plant, Chicago IL Distribution Center, Dayton OH Shipping Plant, Cleveland OH Shipping Plant, Chicago IL Shipping Plant, Chicago IL Warehouse, Kansas City, KS Central Warehouse, Oklahoma City, OK Shipping Plant, Little Rock AR Shipping Plant, St. Louis MO Shipping Plant, Chicago IL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started