Forum Discussion
Solved
Sorting out data from a column
Hi all, I have a very long column (28281 rows) with dates and times (format: dd/mm/yyyy hh;mm). There are no breaks between days, weeks or months: data is continuous. Next two columns are numbers...
Luis Serpa I suggest you look into Power Query as demonstrated in the attached example. In general it's not a good idea to insert empty rows in data sets to hold calculations relating to sub-sets of the data. In your case averages and medians per month.
Thanks, NikolinoDE. Will try it tomorrow.
Cheers
Luis
Cheers
Luis
Luis Serpa I suggest you look into Power Query as demonstrated in the attached example. In general it's not a good idea to insert empty rows in data sets to hold calculations relating to sub-sets of the data. In your case averages and medians per month.
- Thank you so much, Riny. I'm going to try this method, it seems perfect.