Distinct values from multiple columns

[PaulK]

Hi

I'm trying to create a list of distinct values from 3 columns on a sheet the columns are loaded from an excel file, column names are

Pack 1
Pack 2
Pack 3

So I need a new table in the sheet with the distinct values from Pack 1, Pack 2 & Pack 3  (one column with all the distinct values in a separate table).

Is this possible to do at sheet level? Everything I've tried so far has not worked but I'm new to Qlik so I'm sure there is a simple solution.

Thanks

Paul

[Steven35]

Hello Paul,

Pack_Tmp:
LOAD
  Value
From Pack 1.xlsx;

Concatenate(Pack_Tmp)
LOAD
  Value
From Pack 2.xlsx;

Concatenate(Pack_Tmp)
LOAD
  Value
From Pack 3.xlsx

NoConcatenate
Pack:
LOAD distinct
  Value
Resident Pack_Tmp;

Drop Table Pack_Tmp;

Best regards,

Steven