Hey all,
I am sure that I am missing something very easy with what I am trying to do, but every solution I have found so far has missed the mark ever so slightly. I need to take multiple cells and combine them into one, but separate them with a comma. I have tried the concatenate function, but it seems that the only way to separate with a comma will require me to click each cell individually and not in a range? I have tried the TextJoin function and it allowed me to do a range but there was no space in between or a comma. So it seems like there should be something that will allow me to quickly do this, but I'm struggling to find the exact way to do it.
I don't have the data of what I actually need to do, but this is just an example of what I'm wanting. I don't necessarily want to have to type anything for each cell because there will likely be over 100 of them. But basically, I need to go down an entire column and combine them. So with the above photo, it would look like January, February, March, April, and so on.
Any help, ideas, etc. you could provide would be greatly appreciated!
I am sure that I am missing something very easy with what I am trying to do, but every solution I have found so far has missed the mark ever so slightly. I need to take multiple cells and combine them into one, but separate them with a comma. I have tried the concatenate function, but it seems that the only way to separate with a comma will require me to click each cell individually and not in a range? I have tried the TextJoin function and it allowed me to do a range but there was no space in between or a comma. So it seems like there should be something that will allow me to quickly do this, but I'm struggling to find the exact way to do it.
I don't have the data of what I actually need to do, but this is just an example of what I'm wanting. I don't necessarily want to have to type anything for each cell because there will likely be over 100 of them. But basically, I need to go down an entire column and combine them. So with the above photo, it would look like January, February, March, April, and so on.
Any help, ideas, etc. you could provide would be greatly appreciated!