Transpose (rotate) data from rows to columns or vice versa
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa. For example, if your data looks like this, with Sales Regions in the column headings and Quarters along the left side:
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.
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.
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.
Distribute the contents of a cell into adjacent columns
You can divide the contents of a cell and distribute the constituent parts into multiple adjacent cells. For example, if your worksheet contains a column Full Name, you can split that column into two columns—a First Name column and Last Name column.
Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself. There’s no need to use the Fill or Copy commands.
MAKEARRAY function - Microsoft Support
Returns a calculated array of a specified row and column size, by applying a LAMBDA. Syntax =MAKEARRAY(rows, cols, lambda(row, col)) The MAKEARRAY function syntax has the following arguments and parameters: rows The number of rows in the array. Must be greater than zero.
Set up your header row - Microsoft Support
Use Power Query to apply transformations such as rename column headers in the Power Query editor