Skip to main content

Switch Data Format From Wide To Long In 23degrees

This tutorial demonstrates how to switch your dataset from a wide format to a long format in 23degrees.

Published at May 6, 2026
15 min Reading time
1. Introduction

You will learn to reconfigure data columns to better suit analysis and visualization needs.

Introduction
Introduction
3. Select Data Format Settings

Click here to open the data format settings to begin switching the data structure.

Select Data Format Settings
Select Data Format Settings
4. Choose Long Data Format

Click Long to select the long data format, which organizes data into key-value pairs for better analysis. This makes it possible to filter specific values, colour labels or style your legend categorically.

Choose Long Data Format
Choose Long Data Format
5. Open Values Configuration

A new "Values" column will be added to your dataset which are the titles of your previous value columns. You can use this new column to filter or colour your chart.

Open Values Configuration
Open Values Configuration

You have successfully switched your dataset from a wide to a long format in 23degrees, enabling more flexible data analysis. Next, explore how to visualize your transformed data for deeper insights.