Search code examples
google-sheetsgoogle-sheets-query

Transpose column and add separator column

I'm trying to transpose a column from one sheet into a row of another sheet with a new blank column separating each result

=TRANSPOSE(Sheet1!A1:A30)

Whats the easist way to achieve this without having to add a blank row between each of the rows in the orginal sheet

Thanks

Solution

  • I think this may be the easiest way

    split(textjoin("||",,Sheet1!A1:A30),"|",,false)