Concatenate ranges

Using Power-user you concatenate ranges in Excel. This can be useful to merge the content of different columns or rows into a single column or row. 

One typical use case when concatenation is needed is for preparing .csv files.

With Power-user you can concatenate your Excel data with several options, as shown below:

To concatenate a range:

• Click Concatenate from the Excel ribbon
• Select the range you would like to concatenate
• Select the option of your choice:
  • Concatenate Columns: a new column will be created at the right of your selection, containing the concatenation of all columns from your selection.
  • Concatenate Rows: a new row will be created at the bottom of your selection, containing the concatenation of all rows from your selection.
  • Concatenate Cells: a new cell will be added next to your selection, containing the concatenation of all cells in your selection (both columns and rows).
• Select the separator to use for the concatenation: you can choose between different separators, such as a semi column, comma, dash, space, tabulation, line break and more. You can also type your own separator if you need something more custom.
• Check Ignore empty cells if it's relevant in your context.
• By default the concatenation is made as formulas, using the Excel TEXTJOIN function. But you can uncheck Concatenate as formulas if you want to have only values in the resulting range.
• Click OK to validate.