- Minitab Cookbook
- Isaac Newton
- 359字
- 2021-07-16 12:29:19
Transposing the columns of a worksheet
Data is often structured with categories denoted in a row and multiple observations of these dimensions in subsequent columns. This can be a popular format used in Excel worksheets. Here, we will transpose this into the column format that is preferred by Minitab in the following manner:
In the preceding screenshot, we can see that different individuals are listed starting from the second column. Their resting pulse is in first row, and after activity in second row, it is preferable for this data to be transposed.
Getting ready
The data used in this example is in the Pulse workbook.xlx file. To get this data into Minitab, follow the Opening an Excel file in Minitab recipe.
How to do it…
The following instructions will transpose the numeric columns of the Pulse workbook file:
- Click on the Data menu and then click on Transpose Columns.
- Select the subject columns in the left-hand column panel by selecting C2 and dragging down through the columns till the end of the column list. Then click on Select.
- In the Create variable names using column section, enter
C1and click on OK.
How it works…
Columns of different data types cannot be transposed with this command. We cannot transpose column 1 from the original data into the numeric data held by the subject columns. Row one of the original worksheet becomes column one of the transposed worksheet. Mixing data types will generate an error. Instead, variable names should be optionally identified by the row categories if they are given in a column of the original worksheet. Here, we use column one to identify the column names of the transposed data.
See also
- The Opening an Excel file in Minitab recipe
- The Stacking several columns together recipe
- The Stacking blocks of columns at the same time recipes
- 中國國民經濟核算體系修訂問題研究
- INSTANT Citrix XenDesktop 5 Starter
- Microsoft Dynamics GP 2016 Cookbook
- 審計學基礎
- VMware vCloud Director Essentials
- Microsoft Dynamics NAV Financial Management
- 注冊會計師全國統一考試專用教材：審計
- Big Data Visualization
- 陜西國家統計調查專題研究集萃（2006—2015）
- Getting Started with Citrix VDI-in-a-Box
- 下一場全球金融危機的到來：明斯基與金融不穩定
- 項目管理實務（第二版）
- 公司內部審計
- 多項目管理方法及其應用研究（國家社科基金后期資助項目）
- PMP 5A備考寶典