How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.

Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

I also have a table containing students' scores (table 2 from this point). I want Excel to use the information in table 1 to complete the missing column in table 2.