Display row results in column with a formula in an excel report

It is very easy to display a vertical result (in row) but sometimes, I need to show the same result in horizontal (in column).



When I use the formula ?

Every time I need to show the results in column instead in row.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formulas ?




As you can see in the picture above, the orange section is displaying the results of the row 2 in vertical with this simple formula “=B2”, very easy so need more explanation.

Now as shown in the other picture, the green section is displaying the results of the row 2 in horizontal with this formula:


If you put this formula in the sheet2 and the results are in the sheet1, the formula is:



  • 1. $2:$2 is the row where are the results
  • 2. B$2:B2 is the column where the results begin
  • 3. +1 is to tell the formula that it has to display from the column B. Imagine that your results start from the column C or you want only to display the result from the column C, in this case, put “+2”.

Interesting Management