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.