Hi there, Could you please help me with the below stated query. I have provided the input data and I want the output as shown in Output Data table. Input Data: Column1Column2ABC[Null]DEFG[Null]HIJKLM[Null]1234[Null]10abcde[Null][Null]PQrstu[Null]9xyz Output Data: Column1Column2ABCPQrstuDEFG9xyzHIJKLM 1234 10abcde

How to remove null value from the columns.

Hi there,

Could you please help me with the below stated query.

I have provided the input data and I want the output as shown in Output Data table.

Input Data:

Column1	Column2
ABC	[Null]
DEFG	[Null]
HIJKLM	[Null]
1234	[Null]
10abcde	[Null]
[Null]	PQrstu
[Null]	9xyz

Output Data:

Column1	Column2
ABC	PQrstu
DEFG	9xyz
HIJKLM
1234
10abcde

Developer

Accepted answers

atcodedog05

Hi @Mohd-Siddiqui1

Sorry my bad again. Got bit confused

Input:

Output:

Hope this helps : )

blanks3.yxmd

All comments

atcodedog05

Hi @Mohd-Siddiqui1

You a data cleanse tool on columns and make sure below-highlighted options are selected.

Or use Multi-Field formula on the columns

Hope this helps : )

blanks.yxmd

Mohd-Siddiqui1

Hi atcodedog05,

Thanks for the reply.

The input data for the Column2 starts at the 6th row and all are [Null] values till row 5 in Column2. I think your input data for Column2 starting from 1st row only.

I have previously used Data Cleansing Tool to remove [Null] values and it was working successfully, but it is the placement of Data in Column2 which is creating a problem for me.