Google Product Forums

Re: Make spreadsheet into more readable data

Yogi Anand 2012/06/24 7:02
グループへの投稿: Google Docs

カテゴリ: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

sorry, in my preceding post, I meant to say ...

let us say your data is in Sheet1 A1:AX5

then try the following formula in cell A1 of Sheet2

=transpose(Sheet1!A1:AX5) 

Cheers!
Yogi
Cloud Computing -- Google Docs Way