Leave the Windows (default) checked, and click OK.

A File Conversion pop-up window opens.

For this example, the Word file is named 'CH Test File,' and the plain text file is named 'CH Test File Plain.' Once you've chosen the location and named the file, click Save.

Choose the location on your computer where you want to save the plain text file, enter a name for the file, and change the file type to Plain Text.In the Ribbon, click the File tab, and click the Save As option.Open the Word document containing the information you want to convert to Excel.Microsoft Office 2016 and earlier versions.As you can see, you get a new table with your data listed in the opposite direction than it was running before.Ĭlick here to watch this video on YouTube.If you have a table that includes both horizontal and vertical data organization, copy the data, right-click on a new cell, and select the Transpose icon in the Paste Options.Copy the data, right-click on a new cell, and then go to the Transpose icon under the Paste Options. If you have a column of data that you’d like to make into a row, the same process applies. As you can see, your data will flip the other way.Head down to Paste Options > click on the Transpose icon.Right-click on the cell where you want the newly positioned data to start displaying.

This doesn’t work if you cut data, so make sure you’re copying, and not cutting. First, highlight the data you’d like to move, and then copy it by either right-clicking or holding Ctrl + C (Windows) or Command + C (Mac).Let’s say you have a row of data, and you’d like this data to be vertical in a column instead. Don’t change it manually–use Excel’s Transpose function instead. Here’s a quick trick in Excel that can be really handy if you’ve started to enter some data in a row, but decide that you’d like it in a column instead (or vice versa).

Transpose excel 365