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 Saved Kent, Clark CK Hero 12008 Dog 1 5/15/2017 Yes Saved Gardner, Guy GG Hero 12008 Dog 1 5/4/2017 Yes Saved Stark, Tony TS Hero 12208 Cat 2 5/5/2017 Yes Saved Rodgers, Steve SR Hero 12208 Cat 2 5/15/2017 Yes Saved Wayne, Bruce BW Hero 12208 Cat 2 5/4/2017 Saved Allen, Barry BA Hero 12408 Girl 1 5/6/2017 Yes Saved Xavier, Charles CX Hero 12408 Girl 1 5/16/2017 Yes Saved Grey, Jean JG Hero 12408 Family 1 5/4/2017 Yes Of 5 Saved Banner, Bruce BB Hero 12708 Bus 1 5/8/2017 Yes Defeated Villian Saved Summers, Scott SS Hero 12408 Family 1 5/4/2017 Yes Of 5
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col></colgroup>