Excel: Converting a row of data (from Sheet 1) to a column (in Sheet 2)

I have a large data set that I need to move from (Sheet 1) to (Sheet 2). The data is in columns in Sheet 1, but I want to put it into rows on Sheet 2. If possible, I'd like to make it so that if I modify the data in sheet 1, it will automatically modify the data in sheet 2. Any help is greatly appreciated. Example of my problem: Convert (sheet 1 data in columns) A 1 B 2 C 3 D 4 To sheet 2 in rows as follows: A B C D 1 2 3 4

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

This thread is current as of April 11, 2017.

For more resources for Microsoft Excel