Advanced transposer

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.