Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Removing Null or Blank values from each column

RajatRehria
8 - Asteroid

Hi,

 

I have a dataset with multiple columns have Null values in the cells from each column, please check below the Input and the desired results:

 

Thanks.

 

Input:

Col 1Col 2Col 3Col 4Col 5Col 6Col 7Col 8Col 9Col 10Col 11Col 12Col 13Col 14Col 15Col 16Col 17Col 18Col 19Col 20Col 21
11065595 59804666135290 171573839212
  24 635884905761724489025 247231246
25391796419302179 2985 77935034  83 
 938651 84 408160 7676 82 5637512
15 489 9064212953 84534587721430 50
555863969 5992382135 99713186 87731
  7945 338426 5763323742836 59 6429
134731466211683584685723 25652776458 
 5099 9431 3374 28443327395895757720
191823090201590503183 35 7055558555054
4 1658245784 56616821075328918134218
 22 653 9749 775086435 61428806213
5293869645769356312617169698748 8124 

 

Output: This is how I want the result like below table for all 21 columns.

Col 1Col 2….....Col 20Col 21
110 9212
253 246
193 8312
55 7550
15 731
134 6429
450 5820
591 7754
 22 5018
 2 4213
   62 
   24 
1 REPLY 1
Raj
16 - Nebula

@RajatRehria 
find workflow attached
mark done if solved.

Labels
Top Solution Authors