Forum Discussion
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 ...
=IF(COUNTIF($A$2:$A2,$A2)=1,XLOOKUP($A2,$A$2:$A$11,G$2:G$11,,,-1),"")
If you have access to XLOOKUP you can apply this formula. The formula is in cell M2 and copied across range M2:R11 in the example.