Download Tutorial Convert Excel To Comma Separated Values 2022 Pics. Then 0 if the logic is to add the data to the power query editor, use the replace values function under the transform tab. As the user is copying and pasting to another program anyway, this may be just as easy for them.
There are different but pretty lengthy process that you can find, which will eat a no.
Assuming that you have a list of data in range b1:b6, and you want to convert all values in column b to comma separated list in another cell. Enter column data below to convert into comma separated values. You can change the separator character note: Text to columns highlight the column that contains your list.go to data > text to.