Pivot Column to show both different values from same text, not sum

[luismolle]

Hello,

not sure Im searching it in a wrong way, but I could not find anything related.

I have a column I want to pivot, but some text values are equal, and the result Im getting is a sum of both values from this same text values. Image below:

In the case of the highlighted, Im having one column with a sum of the values, while the expectation is to have two column with both values. Everything else is working fine, the only thing is I want two columns when repeated "Column3" values appear under the same "Source Name" value,

tks

[edhans · Accepted solution]

Pivoting automatically groups when the text values are the same, and it also gets rid of nulls. For it to not combine, there needs to be another column that is unique for those records. For example, Lable D is duplicatged, but the dates are different.

when pivoted, I get this:

However, if I don't have unique dates, say that row 5 in the top table was also 1/4/2023, I get this error:

It is because there is a list of {4,5}  that it is trying not to aggregate (it uses List.Distinct) and it cannot get a distinct value for that cell, so it bombs.

You cannot get two column "D's" though. That makes no sense to Power Query. Or any other database.