I have a google spreadsheet that has Sheet1 (tab 1) column values I want to be row value in a column in sheet (tab 2)
So I wrote formula ={'Sheet1'!A2:A35} and it does give me column values from sheet value but the outputs to multiple row (vertically)
is it possible that the row values of column A in sheet 1 to become column values of a single row in sheet 2.
the reason why I want is because in sheet 2 they act has Header to columns.
