Separate and rearrange data

[elvinh]

Hello All,

I am trying to create a work flow to automate an excel sheet I work with. The "Initial Data" tab in the excel file is the raw data I receive and the data I need to get to / reproduce is on the "Result" tab (it doesn't have to be that exact format). 

A few comments about the excel:

- The highlighted cells on the "Initial Data" tab are the ones that I work with to pull the final data out of. 

- The three letter codes in the highlighted cells may move around week to week to the other buckets so the workflow would need to be able to capture that as the weeks change.

- The 'Lowest Bucket' as seen on the "Result" tab, comes from cell 'B4' on the "Initial Data" tab.

I started a workflow that tries to incorporate some RegEx parse formulas, but I don't believe it is the most efficient path to get to my solution. 

I can share this if needed!

Thank you for taking the time to read this and for any help!

[Dina · Accepted solution]

I think this should be it. 

[elvinh]

Thank you, this is awesome, didn't even think about doing it this way! 

[Dina]

I'm glad it helped.