TRANSPOSE and leave 3 blank cells between each outputted cell value

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

>Solution :

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.