I am testing out the trial version of VWR and it seems to work very well. But I have a problem with the data output file. I am exporting the data to an Excel file.
The website content I am scraping is online articles for some marketing and research purposes. The article title and author are in separate columns in rows of the output Excel file which is good. However, the problem is the article paragraphs of text (with Inner html setting to keep the links in the text) is separated into individual rows for each paragraph. What I need is to combine the paragraph text so it's merged into one cell in the row. For example, the way it's outputing now is if the article has 5 paragraphs, then the output Excel file will have 5 rows:
Row 1: first article title, first article author, first paragraph text.
Row 2: first article title, first article author, second paragraph text.
...and so on.

What I need is the output Excel file to be:
Row 1: first article title, first article author, all paragraphs text for first article in this row/cell.
Row 2: second article title, second article author, all paragraphs text for second article in this row/cell.
...and so on.

I can't do the merge within Excel so the only logical and best solution would be to have VWR export the data in the format I need. I'm sure this is something that VWR can easily do, but I just don't know how to do it. Let me know if anyone has advice on this.
Thanks for your help!