To do this, you need to follow the below steps. It allows you to import data from many sources and transform, and reshape the data. How to Concatenate with a Line Break by using Power Query? This method is useful when you want to discrete more number of cells into one.
How to Concatenate with a Line Break by using TEXTJOIN Function? Like the above example image, you can include the formula to Concatenate strings in different cells into a single cell.We can use Concatenate or CONCAT Function in the Formula to discrete the data with line breaks.
How to Concatenate with a Line Break by using CONCATENATE or CONCAT Function?
