Data split

[mihaicom20]

Hello everyone,

I am trying to find a solution in order to split a database in multiple part after a simple condition and I couldn't found a solution on the community. I need to set up the flow to take everything after a common key until it will find it again. Ex:

Col 1

Home

Street 61N

NO: 122

City: New York

Home

Street 122

NO: 332

City: Boston

I want this data to be split on 2 after and the key to me "HOME". I also I have attache you the database that I want to be split and it is split in multiple colours. The spiting key "Total OPEX 2021 - Run (Non-Compliance & Cyber)". Could you please help me with any advises? 

Thank you in advance!

Mihai 

[atcodedog05 · Accepted solution]

Hi @mihaicom20 

You can use formula like this to create blocks of your data on every occurrence of the key words. In your data split keywords suitable are "Total OPEX".

Workflow:

Hope this helps : )

[mihaicom20]

Thank you so much for your help!

[atcodedog05]

Happy to help : ) @mihaicom20