how to make a row into a column in excel for mac

Make A Row Into A Column In Excel Download And Free
Make A Row Into A Column In Excel Download Kutools For

Increases your productivity by 50, and reduces hundreds of mouse clicks for you every day Read More.

In a blank cell C1, please enter this formula: OFFSET(A1,COLUMNS(A1:A1)-1(ROWS(1:1)-1)5,0), and then drag the fill handle from C1 to G1, see screenshot: Note: A1 is the started cell, 5 stands for the number of cells that you want to have in each row.

Meanwhile you must start this formula in the column C.

Then go on dragging the fill handle down to the range as far as you need.

And the single column data has been converted into multiple rows as following screenshot shown: 3.

As they are formulas, when you copy them, you must copy and paste them as values.

Here I will continue to introduce you an easy way to deal with this problem.

With Kutools for Excel s Transform Range feature, you can quickly convert a single row or column data to a range of cells as you need.

Make A Row Into A Column In Excel Download Kutools For

See below demo. Click to download Kutools for Excel After installing Kutools for Excel, please do as this: 1.

Click Kutools Range Transform Range, see screenshot: 3.

In the Transform Range dialog box, specify the settings as follows: Choose Single column to range from Transform type; Specify the cells per row, if you have selected a column with blank cells as separator, you can check Blank cell delimits records, and the data will start a new row at each blank cell.

You can also specify the number of cells per row from the Fixed value that you need.

Then click OK, a Transform Range prompt box will pop out, and click a cell to put the result.

The Output range can be specified in different worksheets and workbooks.

See screenshot: 5.

Click OK, you will see the single column has been transformed to multiple columns in selected cell.

See screenshot: Kutools for Excel s Transform Range tool can help you easily transform a single column to a range, transform a single row to a range, transform a range to a single row and transform a range to a single column.

Make A Row Into A Column In Excel Download And Free

Click to know more Click Download and free trial Kutools for Excel Now The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80 Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails.

Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range.

Merge CellsRowsColumns without losing Data; Split Cells Content; Combine Duplicate RowsColumns.

Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select.

Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more.

Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments.

Super Filter (save and apply filter schemes to other sheets); Advanced Sort by monthweekday, frequency and more; Special Filter by bold, italic.

Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF.

Open and create multiple documents in new tabs of the same window, rather than in new windows.

How To Make A Row Into A Column In Excel For Mac