How to use the TRANSPOSE Function using Formula and with mouse clicks

Today's article is about TRANSPOSE function in both ways - formula & Paste Special step-by-step.

Description

The Microsoft Excel TRANSPOSE function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

The easiest way to use TRANSPOSE is to copy the data, then right click on the cell you want to transpose the data. Click on paste special, select Transpose, click OK. That's it, you are done. (Reference below image).

  

Transpose by Paste Special

Using TRANSPOSE as function is a tricky thing. Hope you know about array (I'll discuss about array after few post from now).

For now, an Array is a set of numbers.

Syntax

The syntax for the TRANSPOSE function in Microsoft Excel is:

Transpose (range)

Parameters or Arguments

range

The range of cells that you want to transpose.

The range value in the TRANSPOSE function must be entered as an array. To enter an array, enter the value and then press Ctrl+Shift+Enter. This will place {} brackets around the formula, indicating that it is an array.

Please don't forget to select all the blank cells you want to put the transposed value, please follow the below image.

If you have any question or query please let me know through comment box.

Transpose using function and Array