Share via

Pivot table: split into columns

Anonymous
2024-08-16T19:41:12+00:00

Hi there!

I'm trying to find a way that I can have this data of the first column individually:

Image 1

Like the total Count of What expectation was missing by its own, not combined as it shows in the second row, but more like in the first row of the Image 1. Something like:

What expectation was missing? Count of What expectation was missing?
Flow 10
General details of the content 12

And I want to be able to filter it using slicers similar to this one

Image 2

However, I'm having a hard time trying to do that. That info, certainly, comes from a Raw data in excel online spreadsheet. So if there's a way to do that, I'd greatly appreciate any help on this. 🙏 If any clarification is needed, I'll be attentive. Thanks in advance!

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2024-08-16T23:32:08+00:00

    Hi,

    In the Power Query Editor, you will have to split that text column into rows. Load that data in the worksheet and then create a Pivot Table.

    0 comments