The feature works by using Text to Columns, which you can access from the “Data” tab in your Microsoft Excel ribbon bar. It does this by separating columns using delimiters, like commas or semicolons, which split up the data. Microsoft Excel includes a special feature that allows you to split up extra long columns. In the window that appears we put the tick near the TRANSPOSE. We click on the command Paste Special (CTRL+ALT+V). We put the cursor anywhere in the Excel worksheet and right-click the menu. We proceed in these steps: We select the entire table and copy it (CTRL + C). To transpose the table, we will use the SPECIAL INSERT command. Learn the Excel keyboard shortcuts (MAC and PC) to paste and transpose. The Income and Expenses sheets have a number of columns for the various types of income, and expenses. Transposing data in Excel for Mac I have an Excel Workbook containing several worksheets, 1 for income, 1 for expenses, and a third that is a quarterly summary. I am doing that but the result is that it just copies a single cell, the 1st one, nothing happens to the other ones selected in the array. I need to switch the values of some rows and columns in excel and I saw that I could use transpose, put the array I need to swap and press CTRL+SHIFT+ENTER. Watch Video – How to Transpose Data in Excel
