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...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.