DB Quacks SQL Tutorial · Chapter 6
Transformers: UNPIVOT in Disguise
Optimus Prime Duck transforms with mechanical sounds. Autobots, roll out! Data transformation emergency! The Decepticons created wide dashboard reports, but we need tall analytical format. Use UNPIVOT - reverse of Agent Smiths work!
Your task
Transform a wide pivot table back to tall format with pond names as rows instead of columns using the wide_data.csv file. You will be converting columns back to rows.