Row concat in excel

tejas.kotharkar · January 18, 2024, 12:45pm

There are 3 columns ID,Name,Results - i want to have the source between master in results. These source row will be dynamic and master will keep on incresing 1,2,3,4

We need to extract the source value
between these masters

Demo Work.xlsx (10.1 KB)

In the result sheet i have showed how i would like to get the results

Thanking you in advance

Yoichi · January 18, 2024, 2:00pm

Hi,

Can you try the following sample?

Sample
Sample20240118-2a.zip (11.0 KB)

Regards,

tejas.kotharkar · January 18, 2024, 2:17pm

Thanks a lot!! It worked

system · January 21, 2024, 2:17pm

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

Topic		Replies	Views
I want to concatnate three rows in excel and want to write in another coloumn,suppose i have three coloumns NAME,ROLE,COMPANY.in 4th coloumn i need all three rows to be concatnate Help excel , activities	6	1552	May 21, 2018
How can I concatenate the rows in excel Studio studio , question , activities_panel	23	1274	September 9, 2022
Concatenate rows Help	4	3652	December 9, 2018
Regarding excel Academy Feedback	9	1231	December 12, 2018
Creating DataRow[] var Help	8	6817	October 29, 2018

Row concat in excel

Related topics