Pivoting Columns with Duplicate ID and Date

[brisacisneros]

Hi everyone,

I'm having trouble pivoting columns in Power Query when I have duplicate IDs and dates in my data. My goal is to have one row for each unique combination of ID and date, with the corresponding hours in separate columns.

Here's a sample of my data:

My goal is to have this structure

[v-achippa]

Hi @brisacisneros,

Thank you for reaching out to Microsoft Fabric Community.

As suggested by @lbendlin could you please provide the sample data of your issue. So that it will be helpfull to narrow down the issue and provide you the best solution possible.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa · Accepted solution]

Hi @brisacisneros,

As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Omid_Motamedise]

After using Pivoting, in the setting use sum operation, then in the result formula in the formula bar, replace List.Sum with each _{0} will solve your problem.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...