Reformatting Data for a line graph
I have a log of information that's sorted first by division, then by date. it's essentially made so that the first of the month, it will grab the data i need and make a monthly snapshot using the copy row feature. it looks basically like this:
I want to make a line graph that will be one line for each division to show the monthly change per division. to look like this:
From what i understand, to do that, the data will need to look something like this instead:
Is there a way that i could transpose this information? I believe that if i i had the dates already filled in to the 2nd sheet, i could use INDEX(MATCH) to look up and fill it in, but I'm not sure how I would fill all the unique dates into the DATE1 column or is there a better way to do it that I'm not considering.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!