Search code examples
google-sheetsuniqueoffsettranspose

Unique values horizontally every *n cell (Gsheets)

I am trying to convert unique values of vertical range to horizontal however I wish to have the output every second cell (see desired output on the image). I have tried offset() and mod() function however it does not seem to work. Could you please give me a clue of how to modify my function?

Function: =unique(transpose(T2:T10))

enter image description here

Solution

  • try this formula

    =transpose(flatten(query(unique(T2:T10),"select Col1, ' ' label ' ''' ") ))

    enter image description here