I have a list that is in Excel, but was sent to me without a header row.
Instead, Column A lists what data should be in the header, repeated for each
entry. Aside from the copy paste special, and transpose command, is there any
way that I can change the data to appear as in rows versus two columns?