[Python,Calc] Group_Concat for the spreadsheet
Posted: Wed Feb 06, 2013 9:31 pm
A most simple draft for an SQL GROUP_CONCAT function as found in many database engines (e.g. HSQLDB 2.x and MySQL).
Select a range of cells so the main category is found in the first column and the subcategories to be concatenated are found in the last column of the selection.
Run the macro.
The 2-column output will be dumped 2 rows below the selection.
Download and save the Writer document to a trusted directory. It contains a Basic installer for the Python script.
Select a range of cells so the main category is found in the first column and the subcategories to be concatenated are found in the last column of the selection.
Run the macro.
The 2-column output will be dumped 2 rows below the selection.
Download and save the Writer document to a trusted directory. It contains a Basic installer for the Python script.