I have a multiple spread sheets that have columns named select your name with a number infront of it.
There is only 1 name per in these columns per row. I need to get all those names into the first column. I'm looking for a way to do this without using =A2&b3&c2 (etc...) reason I don't want to use that formula is because each sheet has this information in different columns and I don't want to have to retype this formula all the time.
If there's a simple way to do this please let me know. attached is an example.
There is only 1 name per in these columns per row. I need to get all those names into the first column. I'm looking for a way to do this without using =A2&b3&c2 (etc...) reason I don't want to use that formula is because each sheet has this information in different columns and I don't want to have to retype this formula all the time.
If there's a simple way to do this please let me know. attached is an example.