14 Replies Latest reply: Jun 5, 2014 5:50 PM by Massimo Grossi RSS

    Make 1 field from 3 fields

      I have three fields in an Excel file: OTR, ISO, IMDL.

       

      OTR has values of  DOUG, BILL, TERI, CHICAGO, MEXICO, DALLAS

      ISO has values of  MARK, PAUL, TONY, RAY

      IMDL has values of   RYAN, PETER, JOHN

       

      I want to make one field called Assigned Pricers (the field will be used

      as a dropdown box to allow my dashboard users to select the Pricer).

      I want it to look like the following:

      DOUG

      BILL

      TERI

      CHICAGO

      MEXICO

      DALLAS

      MARK

      PAUL

      TONY

      RAY

      RYAN

      PETER

      JOHN