Hi,
I've been lurking around the forum for a while learning lots from you and have gone through a number of the tutorials provided :). I have an issue that I just can't seem to resolve however and I'm hoping someone can help me.
I pull data from the Jira API and this returns a record of tickets. Each ticket can have multiple 'component' values, and also multiple 'label' values. The data in PowerBI shows a row for each combination of these (truncated example below)
| Ticket URL | Ticket Number | Labels | Components |
| url/123 | ABC-123 | Label 1 | Component 1 |
| url/123 | ABC-123 | Label 1 | Component 2 |
| url/321 | ABC-321 | Label 2 | Component 1 |
| url/321 | ABC-321 | Label 3 | Component 2 |
| url/321 | ABC-321 | Label 1 | Component 1 |
| url/222 | ABC-222 | Label 2 | Component 1 |
I would like to have only one row for each Ticket Number and combine the various labels into comma-separated values in other columns.
| Ticket URL | Ticket Number | Labels Array | Components Array |
| url/123 | ABC-123 | Label 1 | Component 1, Component 2 |
| url/321 | ABC-321 | Label 1, Label 2, Label 3 | Component 1, Component 2 |
I have also shared some real data in Excel and pbix format - in these you will see that there are a number of other columns that I need to keep. If anyone can help I'd greatly apprecate it!
