Transpose (rotate) data from rows to columns or vice versa
You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns. Here’s how to do it: Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.
Transpose data from rows to columns (or vice versa) in Excel for …
If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice versa. For example, if your data looks like this, with sales regions listed along the …
TRANSPOSE function - Microsoft Support
The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.
How to convert multiple rows and columns to columns and rows …
You can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).
Split text into different columns with the Convert Text to Columns ...
Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard. Try it! Select the cell or column that contains the text you want to split.
Convert numbers stored as text to numbers in Excel
Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.
Convert a data type - Microsoft Support
Use Power Query to convert a data type, such as Date field formatted as month, day, year, hours and minutes
Split data into multiple columns - Microsoft Support
Sometimes, data is consolidated into one column, such as first name and last name. But you might want separate columns for each. So, you can split the Sales Rep first name and last name into two columns. Select the "Sales Rep" column, and …
Parse text as JSON or XML (Power Query) - Microsoft Support
Deconstruct the contents of a column with text strings that contain JavaScript Object Notation (JSON) or Extensible Markup Language (XML).
Pivot columns (Power Query) - Microsoft Support
In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, performs an aggregate calculation for each value, and pivots the column into a new table.