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, 9:53am 11

@supermanPunch @Tapan_Behera1 Thanks guys i got a solution

Regards,
Raja G

2 Likes

Forum Engagement Daily Reports

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

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

How to concatenate two row data in particular column

Related Topics