I need to combine all the content from all cells in a row and then I need to repeat the process down the column:
combine everything from B1 to AA1 into A1
Then I need to repeat the same formula for rows A2, A3, A4, etc.
I know the formula for combining 2 cells into 1 is: =A2&" "&B2
I do not know how to auto repeat it down the row and this same formula does not seem to work for me.
I have 1000s of rows that need to be repeated and the content ranges from names to numbers.
Thank you in advance!!