Hi all, first question on here so will perhaps have overcomplicated this so I shall try explain.
I have attached a screenshot below. I have 20,760 rows (120 rows for each of the mutual funds I am investigating; 173 funds total). The reason I have 120 rows for each fund is due to having a row for each month of the period between January 2006-December 2015 (120 months). I have data on various characteristics of these funds (age, size, manager tenure, etc). What I want to do is ensure each fund has the related characteristic value on the same row as it over the whole time period. For example, if fund A has a management fee of 1.5, I want the value 1.5 to be copied into all 120 rows for that one fund, and then move onto the second fund and it's own management fee, and so on for all 173 funds.
As an example, in the screenshot column K has 173 datapoints on the management fees for each of my funds. I want to not only copy this data all the way down to row 20,760, but also repeat each value a set amount of times before moving onto the next. So for example, I would like to repeat cell K2 exactly 120 times (because that is the value for Fund A), and then immediately move onto the next value (K3) and repeat that exactly 120 times, and so on until all values are repeated 120 times and I reach cell 20,760.
Apologies for the long winded explanation, this is for my dissertation so if anyone could help me out that would be great!
Screen Shot 2018-02-08 at 10.29.03.png
Bookmarks