Changing Row to Column in Self-Service Dataset

Version

Preview

The Row to Column function can change a one-dimensional table into a two-dimensional table.

• One-dimensional table, also known as the pipeline table, has fixed column names. You just need to add data row by row.

• Two-dimensional table is a relational table in which the values in data areas are determined by rows and columns. This table is suitable for displaying analysis results as it is more in line with people's reading habits with denser information.

The document introduces how to perform Row to Column when you edit data.

• Before

• After

Implementation Method

1. Create an analysis subject and upload the example data.

2. Go to the data editing interface and perform Row to Column based on the values of a field to generate a header column.

Example data: Student Score.xlsx

Adding Data

Upload the example data to the analysis subject and go to the data editing interface.

Row to Column

1. Click More > Row to Column.

Convert the content of the Subject field to new columns to display the scores of Biology, Physics and Maths.

2. Drag Subject to Row fields, Score to New column.

3. Tick the three checkboxes under Select the generated new column to display each student's scores of different subjects.

Note:

The number of the generated new columns should not be more than 100.

For details, see section "Preview".