Module 24 : TRANSPOSE

24.1 TRANSPOSE You can use the TRANSPOSE function to switch or rotate cells. There are two ways in which to do this. You can do this by copying, and then using the Transpose option in Paste Special, but be aware that this will create duplicated/static data i.e. any later changes to data in your original columns will not be pulled through to the transposed data. This is the simplest method, which we discuss in the video below. Alternatively, you can type in a formula using the TRANSPOSE func...