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:
This article includes the following tags:
- Microsoft Excel