|
|||
This tool transposes the data selected in the indicated range. Have a look at the example: We wish to transpose the data selected in Range B8, but only as values. We choose the transposing mode we wish, and press the OK button. |
|||
Note that they have only been pasted as values. | |||
More examples on the rest of the options. Pasting data with an exact formula. |
|||
Pasting data as link, to original cells. | |||
Note: You can also run the tool as follows: 1.- Select the range you wish to transpose. 2.- Select the cell where you wish to paste the results (do not forget to select two ranges you must hold down the CTRL key). Finally, press the corresponding button. |
|||
3.- Press the corresponding button. The first click will paste as values. The second click will paste as exact formulas. The third click will paste the data as links. |
|||