I need to stack multiple columns into one big columns...
So if the first column was "first names" and the second column was "last names" I would need to stack it as such:
first names
bob
john
mike
mark
last names
johnson
sears
churchill
evans
I would like to do this in a dynamic way with a formula, so any names added to the list would be reflected in the "single stacked" column.
What is the best way to do this... and actually I would like to also exclude the title of each column so the final results would look like this:
bob
john
mike
mark
johnson
sears
churchill
evans
Thank you for the help!
********update w/ additional details************
example excel file attached, with details on how I'll be using it:
I will be adding additional items in columns F through J
When I do that, I would like for columns A and B to be automatically updated.
...so for example if i add "pear" in cell F8, I want for pear to dynamically populate in cell B7, and "fruit" to populate in cell A8, while the rest of the contents in the column would shift down.
Because the length of the list will chage, the formula would need to have a way of eliminating blank spaces before the list is populated in column A and B.
*****************************************
Bookmarks