Transpose Table

If your data is in Excel, you can use Power Query to unpivot the data.

If it’s in a database, you can try to use a custom SQL to unpivot.

Other than that, you can take a look at Glue Databrew.

1 Like