If your data contains spilled arrays, you can't format it as an Excel table. In this scenario, keep your manual table formatting to a minimum, such as using bold font in the column headers.

Discover two powerful Excel formula methods to unpivot data. Transform cross-tab layouts into analysis-ready formats without Power Query.