You are reading a single comment by @Dugtheslug and its replies.
Click here to read the full conversation.
-
That's a horrendous layout for doing anything with. Much better would be a date in column A, a category in B (use a drop down to make sure they're consistent) and a value in C.
Easiest way to get to this is to unpivot using power query.
This is a random guide I found on Google
https://exceloffthegrid.com/power-query-unpivot-data/
But searching "unpivot using power query" will give you plenty of guides
aggi
@Dugtheslug
Hoping someone can help me... it's a bookkeeping type of thing.
I have a spreadsheet, dates in column 1, then about 20 subsequent named columns, each column having values (in £s) in it if money has been spent on particular dates.
If money was spent on the same date under different headings then that date is repeated in the date column.
I need to create a line graph for each named column showing how the weekly average value (money spent) changes over time.
I can do the line chart bit, but I'm stuffed if I know how the fucking fuck to take all the values in each column and change them into a rolling average value for any given week.
Please help!