Combine Multiple Cells Into One Cell With Comma


#1

Sometimes you have data like this:

1

But what you need is data like that:

2

Just use the link @pow posted below :point_down:


#2

https://convert.town/column-to-comma-separated-list

You welcome. :slight_smile:


#3

Nice thank you should have asked first i guess ^


#4

Sweet link mucho gracias!!


#5

you can you “transpose” when you paste with right mouse click in xls. It changes from vertical to horizontal. Adding the comma you can do before with a simple function. So it is already in XSL. If you want to have the sequence in one cell, it is even easier. Just use formular to add content of the cell above + add ", " and put that in the row next to. Pull down and there you go…


#6

You can use this free tool, that has a few more options:

https://mpsocial.com/t/free-excel-level-2-convert-rows-to-comma-delimited-for-hashtags/10758


#7

Good share.

There’s lots of tools like this online to solve formatting issues, just always google what you’re trying to achieve and “tool” and there’s lots of things to help.

There’s a thread too about tools, somewhere, where you can find out about other handy tools people use.