> [!tldr] The term for stacking tables into triples **Unpivoting** is indeed the term for this kind of transformation: FROM: ```csv ID, Color, Size A, Blue, Large B, Green, Medium ``` TO: ```csv ID, Key, Val A, Color, Blue A, Size, Large B, Color, Green B, Size, Medium ``` It's also called "**Melting**" in [[Pandas]] for the [[Python]] world. In [[Spreadsheet|Excel]] it's Unpivoting. The opposite is called **Casting** and **[[Pivoting]]** **** # More ## Source - claude