How to Concatenate Text Using Group by in Power Query

Learn how to Concatenate Text Using Group by in Power Query. Generally, Group by allows you to summarize data and aggregate the grouped values which are aimed at numbers. However, Group by in Power Query can also perform text-related operations and allow you to concatenate text into a single cell.

This technique works in both Power BI and Excel. In DAX, you can accomplish the same result by using CONCATENATEX.

⏰Time Stamp⏰

0:00 Intro
0:42 Step 1: Convert Data into Table
0:59 Step 2: Load data in Power Query
2:59 Step 3: Create Custom Column
4:41 Step 4: Load data to Excel
4:58 Step 5: Adding New Data and Check the process
4:45: Wrap Up

Watch related Power Query playlists

🚩 Let’s connect on social

🔔 Subscribe to my YouTube channel

#powerquery #excel #powerbi #TechTARSolutions

[haseenasaleem]

Thank you so so much. This was pure genius

[gaybarile]

Thank you for this. This is very helpful