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...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.