Can I convert multiple fields into one?
Below screenshot is the source that I am about to import.
The column F ~ J indicated what types of shipment were made with a letter V.
My question is that can I somehow convert these five fields into one draw-down field after importing?
So on FileMakePro database will only have a field called "shipment type" which contains a draw-down menu with the choices of air shipment, ocean shipment, FedEx, UPS, and Post?