Excel: align data to rows by heading?

I have headings across many columns that are staggered, is there a way to select or reference the headings and get them to snap to a single row (moving all data below with it) each column has 20 or so headings.

This question generated 7 answers. To proceed to the answers, click here.

This thread is current as of October 11, 2014.

For more resources for Microsoft Excel