Hi

I have data listed in Column A in Sheet 1 (Rows 1 to 100) that I would like
to appear as Column Headings in Sheet 2 (Columns A to Column CV). Is there a
formula or drag method that I can place in Sheet 2 that will flow this
information through easily?

Thanks in advance.