Is there functionality in Metabase similar to Panda's melt (pandas.melt — pandas 1.5.1 documentation)?
You'll have to do that in SQL (if it doesn't require some external scripting). Metabase doesn't have a built-in transpose functionality besides Pivot:
https://github.com/metabase/metabase/issues/3769 - upvote by clicking on the first post
Thanks. This looks promissing: Unpivot (Melt) - BigQuery Snippets - Count SQL Snippets