Test Pivot.xlsx
Helo, how can I pivot data in excel and sum the amount by month-year?
Expected output:
APR-2023 MAY-2023 JUN-2023 JULY-2023 AAA BBB CCC
Test Pivot.xlsx
Helo, how can I pivot data in excel and sum the amount by month-year?
Expected output:
APR-2023 MAY-2023 JUN-2023 JULY-2023 AAA BBB CCC
is that what you want?
Last edited by sandy666; 01-27-2023 at 12:37 AM.
Hi Sandy666,
Can you please explain how u did this? As I am also looking for a solution to a similar question.
Regards and Thanks in advance
goodboy
Click on the result table anywhere - Click Data - Click : From Table/Range and the Power Query editor opens ( once you see a post by Sandy, think of PQ :-)). All information is now available
( I suppose PQ comes with an addin in XL2016)
with Power Query as you can see here
btw. Power Query add-in is required for XL2010/2013 only, higher versions have PQ built inPlease Login or Register to view this content.
Last edited by sandy666; 02-05-2023 at 07:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks