I have several columns of data each with its own heading. I need to get the
data within each column to match its respective heading.

Here's a sample of how it looks now:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3: Not Specified

Here's how I'd like it to look:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3:
Not Specified

I'm on Excel 2002. Hopefully, someone can help!