excel transpose formulas without changing references

How to Transpose Columns in Excel

The first step in transposing columns in Excel is to highlight a column and right-click it. Then, select the cell…