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!
