convert columns to rows in excel with formulas

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…