Hey guys! I am doing finance research where I have a couple of thousand columns of historical stock prices with a specific code for each company in the header. It looks something like this:
<tbody>
</tbody>
In the next step i have the same SE-codes for each stock but sometimes i have several of the same code in a row. I am looking for a way to autofill the price history for each stock so that it matches the price history in the first table. So it would look something like this:
<tbody>
</tbody>
Thankful for any help or input!
SE121 | SE122 | SE123 |
1 | 1 | 1 |
2 | 2 | 2 |
<tbody>
</tbody>
In the next step i have the same SE-codes for each stock but sometimes i have several of the same code in a row. I am looking for a way to autofill the price history for each stock so that it matches the price history in the first table. So it would look something like this:
SE121 | SE121 | SE121 | SE122 | SE123 |
1 | 1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 | 2 |
<tbody>
</tbody>
Thankful for any help or input!