In this chapter, we'll be covering the following recipes:
Opening an Excel file in Minitab
Opening data from Access using ODBC
Stacking several columns together
Stacking blocks of columns at the same time
Transposing the columns of a worksheet
Splitting a worksheet by categorical column
Creating a subset of data in a new worksheet
Extracting values from a date/time column
Calculator – basic functions
Calculator – using an if statement
Coding a numeric column to text values
Cleaning up a text column with the calculator