When dealing with data that's been provided to you, we can often find that the data isn't presented in the way we would like it. One particular thing we can find is that what's in a row and what's in a column could be the wrong way round. So in the top table here we've got fruit in our row along the top and then we've got countries down the left-hand side. Ideally, what we'd like is the table at the bottom. We'd like those swapped around, countries in the row along the top and fruit down the left-hand side. So this is transposing. There are a number of ways you can do it. These include paste special, transpose, offset, using the row and column functions as well, offset and match, and index match.