I'm trying to transpose a column of different values into a row with only uniques, where there is a space of three empty cells between each outputted value. current output vs. desired output If anyone has an idea of how to approach this, your input would be greatly appreciated. Thanks y'all

CodePudding user response：

Try

=transpose(flatten(index({unique(A2:A11),
iferror(sequence(countunique(A2:A11),3)/0)})))

Essentially, we are creating a virtual array with the unique values in A2:A11 and 3 blank columns, flattening it and finally transposing it.