Parsing repetitive tables

[franc1s]

Hi.

Hi have some semi formatted data in excel. 

Basically they are repetitive tables for data items. There are some headers and footers around the data.

For each H[x]a I want to read what is listed in H6-8 in columns C0-3. At the moment I am doing this in python. But, I am trying to convert all/most of my python data parsing to Alteryx.

I also thought I was going to be able to find something on the forum, but, apart from scraping html tables, I didnt find anything that I could apply. My thinking was that reading this semi-structured data would have some "recipes".

Thanks kindly for any assistance.

[Sebastiaandb · Accepted solution]

Hi @franc1s ,

This hopefully works for you :-):

Greetings,

Seb

[franc1s]

Many thanks Seb! I will test it. I might have some further questions as I am an absolute beginner. I think that these recipes help my introduction into Alteryx.