I am running excel for Mac, 2011 version. I have this: Dog Cat [blank] [blank] Horse [blank] Rabbit I want to transpose it so it says. Jump to content. My subreddits. Edit subscriptions. Unsolved How to transpose cells with text while ignoring blank cells. Submitted 4 years ago * by yakwool.

By Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button: • Inserting a cell: Select a cell (or multiple cells) and then choose Insert→Cells from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Cells. A small dialog asks you which way to push the existing cells. • Inserting a row: Select a cell (or multiple cells row-wise) and then choose Insert→Rows from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Rows.

Your new, blank row(s) push(es) the current row and the rows beneath down one (or more) row(s). Download flash player for mac sierra. • Inserting a column: Select a cell or multiple cells column-wise and then choose Insert→Columns from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Columns. Your new, blank column(s) push(es) the current column and columns one (or more) column(s) to the right.

You can delete cells, rows, or columns in the following ways. • Deleting a cell: Select a cell and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Cells.

A small dialog asks you which way to move the existing cells. • Deleting a row: Select a row number and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Rows. Your selected row vanishes, and the rows beneath move up one row.

• Deleting a column: Select a column letter and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Columns. Your column disappears, and columns to the right move one to the left.

Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac 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 top and quarters along the left side: You can rotate the columns and rows to show quarters along the top and regions along the side, like this: Here’s how: • Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C. Firefox for os x. Note: Make sure you copy the data to do this. Using the Cut command or CONTROL+X won’t work. • Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Pick a spot in the worksheet that has enough room to paste your data.