hoodedrobin1
New Member
- Joined
- Jun 19, 2017
- Messages
- 10
I have some advance concatenate questions I am having a problem solving.
I have some data that is incorrectly broken into separate rows when scraping data from a website. I want to be able to combine the rows in question into the same row as text found on the left of said column.
Hopefully below someone can see how I need to do. The fifth column (E) is not in one cell and needs to be grouped based on text to the left.
<tbody>
</tbody><colgroup><col></colgroup>
also
<tbody>
</tbody><colgroup><col></colgroup>
I have some data that is incorrectly broken into separate rows when scraping data from a website. I want to be able to combine the rows in question into the same row as text found on the left of said column.
Hopefully below someone can see how I need to do. The fifth column (E) is not in one cell and needs to be grouped based on text to the left.
concatenate column e into row with text for exable E1&E2 concatenate into E2 |
<tbody>
</tbody><colgroup><col></colgroup>
also
concatenate column e into row with text for exable E20&E21&E22 concatenate into E21 |
<tbody>
</tbody><colgroup><col></colgroup>
Saved Parker, Peter PP Hero 12008 Dog 1 5/4/2017 Yes