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)23 February 2026Explode / implode columnsAppend / duplicate rows