Formula for moving a range of cells in one row to a new row
Hello All,
On the small sample inserted below, you will see that every student has a unique number in Column A and each student has two rows of data. I would like to move the data so that every student has only one row of data.
For example, the first student is student number 150 (A2 and A3). I would like to move the data from cell range G3:L3 to M2:R2. I want to do this for every student.
How do I do this? Thank you for your help!
Hello All, On the small sample inserted below, you will see that every student has a unique number in Column A and each student has two rows of data. I would like to move the data so that every student has only one row of data. For example, the first student is student number 150 (A2 and A3). I would like to move the data from cell range G3:L3 to M2:R2. I want to do this for every student. How do I do this? Thank you for your help! Read More
