# xan implode ```txt Implode a CSV file by merging multiple consecutive rows into a single one, where diverging cells will be joined by the pipe character ("|") or any separator given to the --sep flag. This is the inverse of the "explode" command. For instance the following CSV: *file.csv* name,color John,blue John,yellow Mary,red Can be imploded on the "color" column: $ xan implode color --plural file.csv > imploded.csv To produce the following file: *imploded.csv* name,color John,blue|yellow Mary,red Usage: xan implode [options] [] xan implode --help implode options: --sep Separator that will be used to join the diverging cells. [default: |] -P, --pluralize Pluralize (supporting only very simple English-centric cases) the imploded column names. Does not work with -r, --rename. -r, --rename New name for the diverging column. Does not work with -P, --plural. --cmp Restrict the columns to compare to assert whether consecutive rows must be merged. Be aware that this will ignore all other columns to in the given selection so only use this as an optimization trick (because you have some column containing a unique id and/or can guarantee all other cells will be identical). Common options: -h, --help Display this message -o, --output Write output to instead of stdout. -n, --no-headers When set, the first row will not be interpreted as headers. -d, --delimiter The field delimiter for reading CSV data. Must be a single character. ```