Forum Discussion
Pivot Table Help - Counting multiple items in a cell individually
Hello, I need some pivot table help. I’m using Excel 2010 and have scoured google for an answer without success. I currently have a table that looks like this (sample): Office Client...
Hi Amie,
To get the count of Requested Funds for each office, you must separate each record in a separate row as below:
Please find the attached file
Regards,
Haytham
Hi Haytham,
Thanks for the response. I have thousands of entries in my excel data sheet. Is there a fast way to separate each row without having to do it manually?
This can be done easily by using the PowerQuery!
But since you have Excel 2010, you have to download and install the PowerQuery add-in from https://www.microsoft.com/en-us/download/details.aspx?id=39379.
After you install PowerQuery, please follow this GIF to learn how to transform all entries.
Hope that helps
- You can't imagine how helpful your comment was to me, thanks a lot!
