How to concatenate two row data in particular column

Help Studio
, ,
1

Hi Team,

I want to concatenate two row value based blank cell,

Input:
image

Expected Output
image

Please help me anyone for this.

Regards,
Raja G

2

Hi @Raja.G
Can you tell us why did you put concatenated value in the above row

3

Hi @Gokul001

Because single row data coming two cell so i want concatenate in single row and YY no is not unique

Regards,
Raja G

4

Hi @Raja.G check this solution.
ConcatenateRowValue.zip (2.5 KB)

1 Like
5

Hi @Tapan_Behera1

Worked that concatenate row values but unwanted row not removed .

Remove duplicate based on YY no

image

Expected output:
image

Regards,
Raja G

Regards,
Raja G

6

Hi @Raja.G run the this code and check the excel sheet1 and 2 .

ConcatenateRowValue.zip (2.5 KB)

1 Like
7

Hi @Raja.G ,

Do we also have a case where there would be two blank cells continuously ?

If so, do we need to concatenate both the blank space corresponding values to the previous rows ?

8

Hi @Tapan_Behera1

Thanks , concatenate is fine but after concatenate to above then below entire row should remove that only not worked and remove duplicate based on YY no.

Please help me on this

Input
image

Output
image

9

Hi @supermanPunch ,

Wish Many more Happy Returns of the Birthday .

Whatever blank cell come in YY no, i want to concatenate Name column data concatenate to above row, than remove entire row once concatenate below to above than below entire row to remove

Regards,
Raja G

10

@Raja.G ,

Could you Check the below workflow :
DT_ConcatenateColumnValue_BasedOnSpace.zip (10.1 KB)

As we are supposed to concatenate the value to the previous row, we could first reverse the Datatable values, so that we can get the check the condition of spaces first and then append those values to the next row. In this way, we are actually adding the values to the Previous row in the original Datatable.

Let us know if this doesn’t work.

Thank you for the wishes :slightly_smiling_face:

1 Like
11

@supermanPunch @Tapan_Behera1 Thanks guys i got a solution

Regards,
Raja G

2 Likes
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.