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

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

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.

Hi @Slavia_Monteiro

Please refer this post it is similar to your query,

Thanks

Hi

Hope this is what you are looking

Pls let know for any further queries

Cheers @Slavia_Monteiro