Exploratory Community

How to transform wide data into 2-column long data


Suppose you have Sales and Profit data per year. It is in the wide data format - there are columns for Sales by Category and Profit by Category.

Now, you want to transform Sales and Profit data into the long format like the following.

Here is how.

1 Like