Removing Null or Blank values from each column.

[Rajat_Rehria]

Hi Community,

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 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10	Col 11	Col 12	Col 13	Col 14	Col 15	Col 16	Col 17	Col 18	Col 19	Col 20	Col 21
1	10	65	59	5		59	80	46	66	13	52	90		17	1	57	3	83	92	12
		24		63	58	84	90	57	61	72	4	48	90	25		24	72	31	2	46
2	53	91	79	64	19	30	21	79		29	85		77	93	50	34			83
	93	86	51		84		40	81	60		7	67	6		82		5	63	75	12
1	5		4	89		90	64	21	29	53		84	53	45	87	72	14	30		50
5	5	58	6	39	69		59	92	38	21	35		99	71	31	86		87	7	31
		79	45		33	84	26		57	6	33	23	74	28	36		59		64	29
1	34	73	1	46	62	11	68	35	84	68	57	23		2	56	52	77	64	58
	50	99		94	31		33	74		2	84	43	32	73	9	58	95	75	77	20
1	91	82	30	90	20	15	90	50	31	83		35		70	5	55	58	55	50	54
4		16	58	24	57	84		56	61	68	2	10	75	32	8	91	8	13	42	18
	22		65	3		97	49		77	50	86	4	35		61	4	28	80	62	13
5	2	93	86	96	45	76	93	56	31	26	17	16	96	98	7	48		81	24

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

Col 1	Col 2	….....	Col 20	Col 21
1	10		92	12
2	53		2	46
1	93		83	12
5	5		75	50
1	5		7	31
1	34		64	29
4	50		58	20
5	91		77	54
	22		50	18
	2		42	13
			62
			24

[shancmiralles]

Hi ! I'm away from my computer right now so I can't create a WF sample for you.. but you can check this link:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Remove-empty-spaces-across-mul...

[BS_THE_ANALYST]

@Rajat_Rehria 

Supplying a picture of input and output without describing the problem is really not useful and lazy.

That should be a bare minimum if you're expecting others to give their time to help you.

[flying008]

Hi, @Rajat_Rehria 

FYI.