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

@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…

How to concatenate two row data in particular column

Help Studio

Raja.G (Mr.RPABot) October 16, 2022, 7:02am 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

Output

Topic		Replies	Views
How to concatenate two row data of above row to below in particular column Studio studio , question , activities_panel	3	527	October 24, 2022
HOW TO CONCATENATE TWO COLUMNS AND GET IT AS A NEW COLUMN IN DATA TABLE? Help excel , activities , studio	5	10232	May 14, 2019
Based on two column value we need concatenate remain column value Studio datatable , excel , studio , question , activities_panel	15	547	December 31, 2023
Delete duplicate rows after adding content to original row Studio datatable , excel , studio , question	3	738	March 23, 2020
Based on two column value we need concatenate remain column value _ Studio datatable , excel , studio , question , activities_panel	7	473	December 28, 2023

How to concatenate two row data in particular column

Related topics