This action will open the Convert Text to Columns Wizard. To convert this text to columns, you first need to select the cells in question. For example, in the sample worksheet, you can see that the Name column contains information that is probably better suited to two separate columns: If you have a cell in your workbook that contains a lot of text, you have the ability to separate it into separate columns automatically if there is a logical character that separates the text (such as a comma, semi-colon, or period).

An alternative solution would be use to the TRANSPOSE function. The copied data and headers will now appear transposed in the new location:Īnd that’s how easy it is to transpose data in Excel. From the context menu, click Paste Special → Transpose (): Click Home → Copy or press Ctrl + C on your keyboard:Īs you cannot paste transposed data over the source data that you are copying from, right-click on cell G3. To transpose your data, you first need to select the data in question (including headers).

Making this change manually would be a very time consuming process, but luckily Excel 2013 has a way to swap this data for you. Let’s say that you want to have the months appear as columns, while the sales associates appear as rows.

This worksheet shows sales for each salesperson by month:

Excel formula to transpose data