If you have a table with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows, or vice versa, without changing the way the data is visualizedd in the graph.
For example, if your data looks like this:
You can rotate the columns and rows so the table looks like this:
To transpose a table, go the the Widget editing screen, click Options (1) > Table (2) > turn the Transpose option ON (3) and hit Apply.