Return unique values but with blank cells between values

Hi there

I am using Google Sheets and want to return a set of unique values but with blank cells between the returned values.

For instance:

Column A
- list of values

Apple
Banana
Apple
Pear
Grape
Apple
Pear



Column B
- list of unique values with blank rows between

Apple



Banana



Pear




Grape

---


I've tried UNIQUE with SPLIT but it doesn't work.

Any help would be much appreciated.

Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...heets.1217086/)

We are not related.

Please read the message to which I linked that explains why ALL forums have this rule: https://excelguru.ca/a-message-to-forum-cross-posters/

can you please provide an excel file showing the list, and the expected results (manually entered).

then we can work on providing a solution.