Pivoting Column changed my data field into column headers

[Ntshepi]

Hi, there's a comment section column from a Powerapps that makes some parts of some comments column headers. Please suggest how do i stop this from happening

[danextian]

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. 

[v-aatheeque]

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

[Ntshepi · Accepted solution]

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! 

[v-aatheeque]

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.

[Ashish_Mathur]

Hi,

Unable to understand your requirement.  Share some data to work with and show the expected result.

[Ashish_Mathur]

Hi,

Unable to understand your requirement.  Share some data to work with and show the expected result.