Merge 17 columns of data to populate single column with all list of values

[varunvyas]

I have table as source for my report where data values are coming in from 17 different columns

e.g.

employee #      Level_1_User      Level_2_User      Level_3_User     Level_4_User

N000789            N000123             N000234            N000345            N000456

N000147            N000123             N000234            N000876             

N000852            N000123             N000963            N000632            N000888

For above example I wanted to create a single column that sources values from Level_1_User, Level_2_User,Level_3_User,Level_4_User and generates the distinct list of values as result column.

[Vvelarde · Accepted solution]

@varunvyas

Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)

Regards

Victor

Lima - Peru