Datascraping multiple rows but write in one cell

[yannip]

Hi all,

I’m looking for the piece of code to do the following.
In the table below, I have one row of data, but it can be more than one row.
I use data scraping to get it out of the webpage into a datatable, and now I am trying to define the following:
if there is more then one row, it should paste that into 1 field, which I later want to write in an excel file.

So for example:

Column “Link” contains two rows:
Revises
Material

Then I would like to write in one excel cell “revises and material”.

Many thanks

[yannip]

I found the solution in the meantime. For the ones interested:

Assign activity: string.Join(" AND ",dt.AsEnumerable().[Select](Function(s) s.Field(Of String)(“Column1”)).ToArray())