Hello,
I would like some help converting this into a pivot table. There is about 20 columns which are my regions and i have events on the left. I need Q3,Q4, and 2H for all of them. How can i do a pivot to simplify this table and make selections
?
Hello,
I would like some help converting this into a pivot table. There is about 20 columns which are my regions and i have events on the left. I need Q3,Q4, and 2H for all of them. How can i do a pivot to simplify this table and make selections
?
Hi which is your excel version please. Answers are tailored to the OP's version. Thanks
excel version 2204
Row 4 is filled with merged cells.
I advice you not to work with merged cells.
It is allowed to change those date?
Excel version
There is no excel version 2204.
Do you mean 2021.
If so, add that in your profile.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I see, yes 2021.
Could you send me a updated excel file how you would sort this then if its not with merged cells. and with the pivot table to have a understanding? Please & Thank you!
With the VBA code below.
See the attached file.Please Login or Register to view this content.
Please change the profile (as requested).
That works! Can you provide that same tabular view for this one filled out?
See also the comments in the (same) threath below.
https://www.excelforum.com/excel-cha...for-pivot.html
Here the file with a button to run the code.
See the attached file.
Last edited by oeldere; 08-16-2022 at 02:12 PM.
the data is pulling incorrectly, for example look at NY METRO and data is different
the data is pulling incorrectly, for example look at NY METRO and data is different
Is the point the names in the files are not the same?
I copied the not merged cells from #6 into this file, so I did not have to change the merged cells.
If that is the problem, change the date in row 2 and run the code again.
Please reply afterwards.
When i click on run it gives me error as well.
Please post the amended file, so I can take a look.
i changed the data and its still giviving me the wrong data for NJ METRO FIRE example
the macro runs now but data is inccorect, for example choose region NJ METRO and Name FIRE & SAFTEY, the numbers are diffrenr
i need them to tie out to this one
I can't see what is going wrong if I don't have the file.
Please also take the time to mark the other question solved.
Please also add the office version in your profile (now you have excel)
Please post the amended file, so I can take a look.
look at line 27 NJ METRO, the file you provided and the one i provided the numbers are off for fire and safety
You have to save the file as a xlsm file (macro's allowed).
Otherwise the macro won't work.
See the attached file and please reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks