How to transpose data columns in Flourish
When starting a new Flourish visualization, you may notice that all templates come with dummy data already imported in the chart. The main reason for this is to showcase how your data should be structured before uploading.
Some Flourish templates use long data format, while others work with wide.
For example, our Line, Bar, Pie charts need wide data. This means that your labels or time have to be placed into a single column, whereas your categories must be divided into separate columns:
But what if your data looks like this instead?
Worry not - you can transpose your rows and columns directly within Flourish!