Three Fields into one field

[#1]

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 with values (the field will

be used as a dropdown box to allow my dashboard users to select the Pricer):

I want oit to look like the following:

DOUG

BILL

TERI

CHICAGO

MEXICO

DALLAS

MARK

PAUL

TONY

RAY

RYAN

PETER

JOHN

[#2]

It is possible to accomplish this through the use of the Crosstable function in the script. I am not sure how your data is formatted in Excel, but a quick test of the following provided the new "Pricer" field as you are looking for...

CreatePricer:

Crosstable(Col2,Pricer)
LOAD * INLINE [
Col1, Col2
OTR, Doug
OTR, Bill
OTR, Teri
OTR, Chicago
OTR, Mexico
OTR, Dallas
ISO, Mark
ISO, Paul
ISO, Tony
ISO, Ray
IMDL, Ryan
IMDL, Peter
IMDL, John
];

Good luck

[maxgro]

did you check the answers  for (it seems to me) the same request

Make 1 field from 3 fields

[#4]

It turned out I had duplicate requests. Sorry.