sophie giesen
New Member
Hi
I have been given some data to work on a problem but it needs manipulating before I can start to work on it. Specifically, I have daily level data for approx 2 years which I need to split down to 15 min level data. I have a template for each interval for Monday-Friday (5 interval templates) but I haven't successfully been able to create a formula or macro to take the daily result and split it out based on the day of week in a single file. I have attached a sample file with tabs showing the daily results format and the templates, as well as an example of what I need the data to look like at the end of the process. Any help would be super appreciated!!! going a bit crazy on this one
Thanks heaps!!!
I have been given some data to work on a problem but it needs manipulating before I can start to work on it. Specifically, I have daily level data for approx 2 years which I need to split down to 15 min level data. I have a template for each interval for Monday-Friday (5 interval templates) but I haven't successfully been able to create a formula or macro to take the daily result and split it out based on the day of week in a single file. I have attached a sample file with tabs showing the daily results format and the templates, as well as an example of what I need the data to look like at the end of the process. Any help would be super appreciated!!! going a bit crazy on this one
Thanks heaps!!!