Excel, scaling columns load statement

[#1]

Goodday clever QlikView peoples,

Here is one for you, refer to Excel extract below:

RowNo	Classification1	Classification2	Classification3	Classification4	Classification5
1	Oracle Database Services	Administration
2	Business Application Services	Support	Application Support by Third Party
3	Service Support Services	Change Management Services	Business Application Services	Standard Change	Pre-approved
4	SQL Database Services	Automated Alert
5	SQL Database Services	Automated Alert
6	SQL Database Services	Automated Alert
7	SQL Database Services	Automated Alert
8	Monitoring Services	Automated Alert Reaction	Server Services	Data Base Services
9	SQL Database Services	Automated Alert
10	SQL Database Services	Database	Configuration

I'm looking to get the value where the classification ends. I.E

RowNo 1 final classification was Administration

RowNo 2 final classification was Application Support by Third Party

RowNo 3 final classification was Pre-approved

RowNo 4 final classification was Automated Alert

etc,etc

Your load statement would be highly appreciated

[Gysbert_Wassenaar]

LOAD

     RowNo,

     If(Len(Trim(Classification5)),Classification5,

          if(Len(Trim(Classification4)),Classification4,

               if(Len(Trim(Classification3)),Classification3,

                    if(Len(Trim(Classification2)),Classification2,Classification1 ) ) ) ) as Classification

FROM ...source... ;

[maximiliano_vel]

I'm sorry I don't understand, Gysbert approach is correct, here are the results

RowNo	Classification
1	Administration
2	Application Support by Third Party
3	Pre-approved
4	Automated Alert
5	Automated Alert
6	Automated Alert
7	Automated Alert
8	Data Base Services
9	Automated Alert
10	Configuration

Isn't this what you need?