Forum Discussion
Pivoting Column changed my data field into column headers
Hi there my good people. I found a solution to my earlier predicament. I hadn't noticed the slight but impactful mistake I made- I split my values column with a comma delimeter, which caused the few comments that had a comma in them get split as well. Ah, the tales of being an entry level data analyst starting with Power Bi... Thank you all for your messages!
Hi Ntshepi
That is exactly what pivoting does - very similar to what pivot in Excel does. Post a workable sample data (not an image) and your expected result from that.
Hi
Following up to confirm if the earlier responses addressed your query. If not, please share the sample data and we’ll assist further.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Hi there my good people. I found a solution to my earlier predicament. I hadn't noticed the slight but impactful mistake I made- I split my values column with a comma delimeter, which caused the few comments that had a comma in them get split as well. Ah, the tales of being an entry level data analyst starting with Power Bi... Thank you all for your messages!
Hi Ntshepi
That’s great to hear, thank you for the update!Glad you were able to identify the root cause and resolve the issue.