Convert two-column scraped data into a proper datatable

I am scraping data from this page. I’m only interested in the table labeled “Partes:” (the middle element on the page).

The data here is in two columns. After scraping I get the following result:
|Column-1|Column-2|
|Nome:|Designação:|
|ALCINDO BIRON NASSIFF|RÉU|
|Advogado:|OAB:|
|PAULO EDUARDO DUARTE DE OLIVEIRA JÚNIOR|RS 78852|
|Nome:|Designação:|
|JUSTIÇA PÚBLICA|AUTORA|

I want to convert this to the following format:
|Nome:|Designação:|Advogado:|OAB:|Nome:|Designação:|
|ALCINDO BIRON NASSIFF|RÉU|PAULO EDUARDO DUARTE DE OLIVEIRA JÚNIOR|RS 78852|JUSTIÇA PÚBLICA|AUTORA|

So all the headers are in one row and all the values in the second row.
How can I perform this transformation?

Hi,

Hope the following sample helps you.

Sequence.xaml (11.4 KB)

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.