Pivot / gather columnspivot — transforms column values into new columns (long to wide)gather — collects values from several columns into two key and value columns (wide to long)18 September 2025Explode / implode columnsAppend / duplicate rows