Spliiting 1 row of data into 2 lines based on next unique value

Hi

I do not know if this is possible, is there any way I can, via code or formula, split one line of data into 2 rows where the next unique value is shown? So basically take the line in red and create the data in the green rows?

Its more of a nice to have than a need to have but would be nice to do if possible.

Maybe:

Please Login or Register  to view this content.