transpose () function

3 Ways to Transpose Data in Microsoft Excel

In Microsoft Excel, you can flip your data sideways, a process known as “transposing data.” Let’s say after an hour of tedious work, you created a table with multiple rows and columns. Unfortunately, you see that the data’s positions are not right. You have to switch specific rows into columns and some columns into rows.