HI
Is it possible to have a blank row between each result when using a Unique or Filter Formula
E.G. In example below in column A I have a list of things. In D1 I have a regular formula =UNIQUE(A1:A10)
Is it possible using the formula to get the list from Col D with a blank row between the results i.e. Col F
Is it possible to have a blank row between each result when using a Unique or Filter Formula
E.G. In example below in column A I have a list of things. In D1 I have a regular formula =UNIQUE(A1:A10)
Is it possible using the formula to get the list from Col D with a blank row between the results i.e. Col F
A | B | C | D | E | F | |
1 | cat | cat | cat | |||
2 | dog | dog | ||||
3 | cat | badger | dog | |||
4 | badger | ant | ||||
5 | ant | badger | ||||
6 | ||||||
7 | ant | |||||
8 |