I would like to group my data together based on date.
I would like to group my data together based on date.
by days...
That's not really what I am looking for. My apologies for not being more specific. One way to do it would be to take every line of data that is batched by date and put it on it's own page. like below.
A way to do this quickly would be to produce a pivot table (PT) of the data on Sheet2 then use the Show Report Filter Pages method described in the linked article.
Note that to display the dates in addition to using the dates as the filter field, column E was added to the original data and populated using: =D2
Note that the resulting Sheet names are in descending order. i.e. Sheet21 contains the data from 4/9, Sheet20 contains the data from 5/9 etc.
Let us know if you have any questions.
https://www.excelcampus.com/pivot-ta...-filter-pages/
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks