Return unique values but with blank cells between values (Google Sheets)

[FKalinx]

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

 

[Jimmypop]

Brilliant, thank you

If I wanted to add more blank cells, is there an easy way to adjust the formula, say for 10 blanks?

In the section

" , , , , , ,"

just add a space and comma after the last comma for an extra space so if you add this to current lets say two comma, you will get extra two spaces...

 

[FKalinx]

In the section

" , , , , , ,"

just add a space and comma after the last comma for an extra space so if you add this to current lets say two comma, you will get extra two spaces...

Thanks