Formula to find unique values from a list

[andrei461]

Hello friends,

I have a list of Items (Col. B). i had derived an array formula to find out unique values(Col. D) from the list.

what i needed was a formula which will derive unique values from the list and show it in every alternate rows(as sown in Col. F) not in continuous rows.

thanks in advance