How to transpose multiple rows and columns in Excel in one shot

Using the Transpose feature of Paste Special in Excel can help you convert a row data into column, and column data into row.
But instead of transposing 1 single row or column, you may need to transpose multiple rows and columns together. This is very easily possible as well.
________________

SUBSCRIBE NOW!

Click this link to learn the most essentials of Excel

Click this link to learn more awesome functions in Excel

[marianndoj]

In Excel, I hyperlink a number with an image (e.g., number 1 with image 1), but I do this for each image separately. How can I select multiple images and hyperlink them to the corresponding images simultaneously (e.g., numbers 1, 2, 3, 4, 5, 6, 7, 8, 9 to become hyperlinks for images 1, 2, 3, 4, 5, 6, 7, 8, 9) synchronously?

[theFlanster]

Hi, question:

Is there a way to transpose one column into multiple colums of several rows?. For example I have all my data on one long column. I need to separate every three points of data into its own column of three. so a 1x9 turned into a 3x3. with data still going downwards. as in the first 1, 2, 3 poitns from the 1x9 would be rows 1, 2, 3 in coolumn 1 of the new 3x3. and 4, 5, 6 of the 1x9 would again be rows 1, 2, 3 in column 2 of the new 3x3