I have a list of students that I want to put into groups of two. I am trying to use the concatenate formula to combine the first two cells in the column (A2 & A3). The second concatenate should go to A4 & A5, and so on. However, when I click and drag or copy and paste excel goes to the next line (A5 & A6) instead of A6 & A7. I am unsure if I should use another formula like transpose with an array, or find another way to make excel recognize the pattern.
I would also like to know how to do it for groups of 3 & 4 as well. Any help is appreciated.
Please see the attachment for the list of students and what the output should be. I entered the output by hand (manually typing the formula) but I would love to see if there was a faster way.
Bookmarks