combining the fields

[#1]

Hi All,

i want to combine 4 columns( F, G, H, I) with 120 lines

to single 1 column with 480 lines

How can i do this

Thanks a lot

[Anonymous · Accepted solution]

Hm, sounds like you want to do something like this:

Load

     Field1,

     Field2,

     etc,

subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';') as DS_DELAY_SUB_CODE

From EXCELFILE.....

[#3]

thank you very much

[#4]

can you also help me about this subject i want to have subfileds  without '?' marks

is it possible or is there an easy way