Combining multiple fields' values into one

[jacqueshol]

Hi All,

I hope someone here can help me. I've been searching answers on this blog (and elsewhere ), but have not been able to find a solution for my problem.  Although I am pretty sure, someone here will be able to help me with a very simple solution.

I am trying to combine the values of 4 fields (VCCostSubType, FCCostSubType, DepotCostSubType, AdminCostSubType) from 4 different Excel spreadsheets into one field (named GroupSubType).  This field (GroupSubType) must show me the contents of these 4 fields as one long list. Basically appended to each other.

For example,

VCCostSubType has values of Fuel, Maintenance, Tyres

and

FCCostSubType has values of Depreciation, Insurance, Claims

and

DepotCostSubType has values of Salaries, Rent, Security

and

AdminCostSubType has values of Telephone, Vehicle_Hire, Audit_Fees

the resultant list box has to be:

GroupSubType
Fuel Maintenance Tyres Depreciation Insurance Claims Salaries Rent Security Telephone Vehicle_Hire Audit_Fees

I need to be clear.  I don't need concatenation, e.g. = field1 & field 2 resulting in FuelDepreciation.  It needs to be presented as one long list made up of separate values.  I also can't do a manual inline load, as the values changes on a month to month basis and can be quite extensive.  Each of these 4 fields can have up to 60-80 values each.

Thanking you all in anticipation.

Take care,

Jacques

[kaushiknsolanki · Accepted solution]

Hi,

You can do like this.

Load VCCostSubType  as GroupSubType from XYZ;

Concatenate

Load FCCostSubType as GroupSubType from XYZ1;

Concatenate

Load DepotCostSubType as GroupSubType from XYZ2;

Concatenate

Load AdminCostSubType as GroupSubType from XYZ3;

Regards,

Kaushik Solanki

[jacqueshol]

Thank you so much Kaushik! Wow, that was quick! And the solution works perfectly

Thanks again.

Cheers,

Jacques