LibreOffice Calc Separate Cells Into Comma Separated Values
Use the =TEXTJOIN(",",1,A:A)
This will join all values in the A-column into a single cell separated by ",". You can of course change the value to whatever you like.
Use the =TEXTJOIN(",",1,A:A)
This will join all values in the A-column into a single cell separated by ",". You can of course change the value to whatever you like.
Attached you will find my neat collection of VBA code to optimize your Excel spreadsheets. Enjoy!
Contact me for more info and spreadsheet development. Thanks!