VLOOKUP or similar way of archieving this task

I am currently working on a table which it an be I want to auto fill multiple cell in when they are matching a merge cell, I have created an example attached.
Sorry I don't really know how to explain in words but I hope the attachment will show what I want, if there is any question please ask as I found this is very difficult and I need help from you guys.

Try this,

O2
=IF(LOOKUP(2,1/($L$2:L2<>""),$L$2:L2)="Type 1",LOOKUP(2,1/($L$2:L2<>""),ROW()-ROW($L$2:L2)+1)&"a",CHAR(CODE("a")+LOOKUP(2,1/($L$2:L2<>""),ROW()-ROW($L$2:L2)))&"a")

copied down.