Transpose columns to rows

Is there a way either in data modeling or in workbooks to transpose columns to rows in a source table? In other words, go from a short, wide format to a long, skinny format. Using the Pivot Table doesn’t work because it imposes a hierarchy of the values. I’m thinking of something comparable to the UNPIVOT function in Snowflake.