combine multiple rows into one column excel

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…