Six hours of working with this issue. Tried every online proposed solution.
Showing years as a column heading should be standard, or at least possible. It should not be complex, alas, I can't find a way to do it.
Will someone please show me how to display years as column headings?
Edit: I started with a new Pivot, entered items for rows, then for columns, after entering some column items, years, months, and qtrs appeared. So, the secret the order and where the items are placed?
Last edited by robvasi; 01-21-2024 at 06:46 AM.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I attached a truncated version of the spreadsheet. The Date does not expand into years and months.
I tried to use the Group to expand the Date, to no avail.
I expanded your dates to generate the years and placed it as column headers.
Please show how this was done,
HOW did you do it?I expanded your dates to generate the years and placed it as column headers.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks