Hi evene,

that was great exercise for me... so thank you...

See attached test file.

I had to create unique value list from col A (and it is dynamic), so when your source reaches more tha 12 unique values, drag down the formula in col E.

It is a little bit complicated with the extract - you have to copy the blocks down (not dragging) and of course, drag to the right if necessary.

So pls do some tests and let me know if it is ok for You...

test (1).xlsx

Hope it helps

Regards

M