Hey all!
I am processing data downloaded from a Bloomberg terminal for over 8000 firms, but I am experiencing difficulty. The data set is in the current format:
<tbody>
</tbody>
I need the data to be in the following format:
<tbody>
</tbody>
I'm sure there's a way to do this using OFFSET and other tools but I can't figure it out. If need be, VBA is fine too, but formulas would be preferred if at all possible. Thanks in advance!
I am processing data downloaded from a Bloomberg terminal for over 8000 firms, but I am experiencing difficulty. The data set is in the current format:
AAPL | BAC | |
1/1/2018 | 0.0430 | -0.0131 |
1/2/2018 | 4.6958 | 0.1438 |
1/3/2018 | 0.8888 | -0.1045 |
1/4/2018 | 1.0708 | -0.4836 |
1/5/2018 | 2.5748 | -0.3809 |
<tbody>
</tbody>
I need the data to be in the following format:
Date | Ticker | RET |
1/1/2018 | AAPL | 0.0430 |
1/2/2018 | AAPL | 4.6958 |
1/3/2018 | AAPL | 0.8888 |
1/4/2018 | AAPL | 1.0708 |
1/5/2018 | AAPL | 2.5748 |
1/1/2018 | BAC | -0.0131 |
1/2/2018 | BAC | 0.1438 |
1/3/2018 | BAC | -0.1045 |
1/4/2018 | BAC | -0.4836 |
1/5/2018 | BAC | -0.3809 |
<tbody>
</tbody>
I'm sure there's a way to do this using OFFSET and other tools but I can't figure it out. If need be, VBA is fine too, but formulas would be preferred if at all possible. Thanks in advance!