Changing Columns to Rows (Reverse Data Pivot)

Version

Expected Effect

Column to Row refers to converting a two-dimensional table to a one-dimensional table.

A one-dimensional table is also commonly referred to as a pipeline table, which has fixed column names. You just need to add data row by row.

A two-dimensional table is a kind of relational table, in which the value needs to be determined by both rows and columns.

Regarding data relationships, the two-dimensional table has a clear feature: Some fields in the column have the same nature. However, every field in the one-dimensional table is unique.

For example, the following figure shows a two-dimensional table: City Consumption and Expenditure.

1. After the sample table is converted to a one-dimensional table, each column in the table is an independent dimension, which is more suitable for data analysis. For example, after the table City Consumption and Expenditure is added to a new dataset and processed, the data in the columns Consumption Amount and Expenditure Amount are displayed row by row.

2. Drag the processed data in a group table. The following figure shows the data effect.

Implementation Method

Edit data in an analysis subject and use the Column to Row function.

Adding Data

You can download the sample data: City Consumption and Expenditure.xlsx.

Upload the sample data to an analysis subject. Go to the data editing interface of the City Consumption and Expenditure table.

Column to Row

1. Choose More > Column to Row.

2. Merge the columns Consumption Amount and Expenditure Amount. Select these two fields.

Effect Display

For the effect, see section "Expected Effect."