I have a table in a Google Document. How can I convert rows into columns, i.e. transpose the table?
Example:
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI have a table in a Google Document. How can I convert rows into columns, i.e. transpose the table?
Example:
I would use the transpose
command of Sheets for this.
=transpose(A1:E7)
I tested this with a table similar to yours, containing linebreaks in some cells. The only thing lost in the process was the text alignment: the output of transpose
command always has the default alignment (right-aligned numbers, left-aligned text). But this is not hard to fix manually.