Grouping DocID Column to show all data points

[stackedcreative]

Hi.  I have a unique DocID column.  There are 4 separate workflows for each DocID (Create, HR Process, Package Selection, Service Process).  Problem is, they are in separate rows.  I need to show them all in the same row.  

I tried:

- CTRL+click in visual > Group (but it's greyed out)

- Data > Data Groups (but it wants me to group by individual DocIDs)

- Tooltips (but they, again, only show the data for that one workflow, not all

For the attached image, I want to show Create Date = X, HR Process Date = Y, Package Selection = Z, Service Process = A) all in the same row.  Basically like a "transpose" function in Excel. 

[stackedcreative]

@DataInsights  Thanks for trying to help.  I've hit so many issues with the data coming in mismatched that I haven't had time to try to get this to work beyond that.  Pivoting does seem the way to go but I get errors.  😞  A colleague had a different idea of a way to display the data so we're going down that path. 

[DataInsights]

@stackedcreative,

Try this measure:

Concat = CONCATENATEX ( DocTable, DocTable[WFAction], ", " )

[DataInsights]

You can adjust the second argument to include multiple columns, like this:

Concat = CONCATENATEX ( DocTable, DocTable[WFAction] & " = " & DocTable[JoinDate], ", " )

[stackedcreative]

@DataInsights - FINALLY had time to work on this.  I need the data to still be in separate columns.  I ran this and got about 6,000 pieces of data in one... makes it hard to put in something readable.  

I tried UNION, have looked into other stuff.  Still perplexed. 

[DataInsights]

@stackedcreative,

Try pivoting the WFAction column in Power Query: