How to swap the contents rows and columns in a spreadsheet?

A

Andrew

Are there ways to swap the contents in the rows and the columns?
ie.
A1 B1 --> A1 A2
A2 B2 --> B1 B2
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from 205 columns to 1 column 4
Lookup / Summary Table 8
multiplication of two array in a particular way 2
Adding rows based on no of rows specified from a given position 1
Accessing sheets based on cell contents 3
Copy Data from One Spreadsheet to Another ?????? 5
Conditional formatting a range of cells 3
formula that writes to a *different* cell? 4

Top