![]() If the table contains variables with the same data types (e.g. Because the resulting columns contain values with different data types, they were automatically converted to universal string types. In the result, the transposed table contains one line less, because values of selected variable was used as the names of the new table columns. If these values are not unique, the program automatically adds the postfix values "_" together with the order number to the individual names. In the following example, we chose the C variable that contains string values. Ather this change, you will see a new combo-box From, where you select a variable (column) whose values will be used as the names of the new table header. If you set this property to FALSE, only table values will be included to the table transposition - the first column (containing variable names) will not be created.Īnother option is to set the Create New Header property to TRUE. The other columns are created from the values that formed the content of input dataset. With this setup, column names of input table ( A to D) will be displayed in first column of the new table. By default, the Include Header property is set to TRUE. If you click on the Transpose function, the parameters Include Header and Create New Header appear in the Properties Panel.īy setting these parameters you can get 4 slightly different results. Subsequently, the function is added to the list of applied functions in the side panel. If you want to transpose this table, click on the Transpose button in the ribbon toolbar tab Reshape. In our example, we use the following table with 4 variables (columns) and 11 records (rows). On the other hand, if you want to continue working with these data, they need to be transposed - analyzes should be made up of individual rows and component measurements should be in individual columns. This table form is easier to read for a small number of analyzes. With the need for this transformation I often encounter, for example, when I work with chemical analyzes - I get them in the form where the individual analyzes are listed in columns and the values of individual chemical components are listed in rows. The example is shown in the following figure. With this function, you can convert columns to rows and rows to columns - transpose. With the Transpose function, you can "geometrically" transform your Excel tables. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |