Forum Discussion
Sorting out data from a column
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.
Hi NikolinoDE, many thanks.
OS: Windows 10
Excel version: H&S 2019
Fil'e attached. It's public data, no sensitive info.
Tanks
Luis
Crear o eliminar una lista personalizada para ordenar y rellenar datos
In the attached file the example with the table.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
- Thanks, NikolinoDE. Will try it tomorrow.
Cheers
LuisLuis 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.