Join/ Merge the Rows into a single row in a data table

Help Activities
, , , , ,
1

Scenario
image

Needed output
image

Merge/join the rows based on Column Customer ID. I need to work with 20 such columns and 20 such tables.

Thanks in advance.

1 Like
2

Hi ,

The options are .

  1. Using loop to go through distinct records are concat it and store to another DT.
  2. The same can be looped but using Linq.
3

Hi @Slavia_Monteiro

Please refer this post it is similar to your query,

Thanks

4

Hi

Hope this is what you are looking

Pls let know for any further queries

Cheers @Slavia_Monteiro

5

Can anyone post sample code. Thank you!

6

@James_Moore

1 Like