You can also pivot your data by using a custom SQL query, by simply adding the UNION ALL operator to it.