Extracting A Continuous List Based On Criteria HELP req...

Hi All,

I want to extract text from column A into column D,E,F based on condition on column B. I am able to do this by IF statement, but the data is not continuous. I want to extract continuous data into D,E,F columns without any gaps.

Condition for Column D: >1
Condition for Column E: >0.5<1
Condition for Column F: <0.5

I am attaching the sample list for reference.

Please help.......