Transposes grouped data from columns to rows in Excel using Paste Special, Power Query, or dynamic formulas.