Hi, I've connected metabase to mysql. Through a query, I'm getting a table where I have location, item and count.
I want to transform this data into a table where first column is item, location1, location2, location3...
So, each location will appear as a column and that column will show the count. Keep in mind the items and locations are dynamic.
Use a pivot table.