Help with concatenating values (in a new column) for an existing column's values

Sindrin

New Member
Joined
Jan 6, 2021
Messages
24
Office Version
  1. 2013
Platform
  1. Windows
Hi Guys,

I have a flat table in PowerBI.

I have a table with a column 'Unique Swap Identifier' and this contains rows of values (FYI some of these values are repeated, some unique)

e.g. in this order
ABC123
ABC123
DEF567
XYZ890
DEF567
etc...

There is another existing column which is titled 'Error Description'

e.g. in this order
Issue 1
Issue 7
Issue 1
Issue 9
Issue 9
etc...

Is it possible to add a new column (at the end) where it concatenates the error description column values based on the Unique Swap Identifier column?

e.g.

On the same row for ABC 123, there would an additional column where it shows the concatenated error descriptions for ABC 123 (e.g. Issue 1 ; Issue 7)

Another example for DEF567 the concat values would be 'Issue 1 ; Issue 9'

Many thanks in advance,
Prinz
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,223,721
Messages
6,174,096
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top