The Data is this but need to show on a Powerbi table side by side Pivot not working

[ResearchDev]

Currently the data is this. There are a other columns to the right but I need it to show in a PowerBI Table visual side by side below. Management wants to see in a Row format (some IDs there are 3 employees involved while some has only one). The data when imported from a sharepoint online list is the one shown below. I tried to Unpivot other columns but somehow it is not working.  Is there a way to put the data side by side in a row as some project ID has several members involved and they want to know right. What is the best approach?

ID	Owner 1	Owner2	Owner 3
111	Daniel C	Eric W	Chris Y

In the Powerquery editor

[NickolajJessen · Accepted solution]

Keep your data as is and just do a ConcatenateX as so:

[NickolajJessen · Accepted solution]

Keep your data as is and just do a ConcatenateX as so:

[ResearchDev · Accepted solution]

I got it working using Table.Column([IDTest],"Owner")