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
Solved! Go to 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 : )
Thank you so much for your help!
Happy to help : ) @mihaicom20