Hi experts,
I'd like to insert a new row for each date EUR and its rate 1. How can I do this?
Below is my dataset and I want to achieve the dataset at the very bottom.
Could you please help me?
Many thanks
| Date | currency | rate |
| 01/10/2020 | USD | 1.1752 |
| 01/10/2020 | BGN | 1.9558 |
| 01/10/2020 | AUD | 1.6319 |
| 02/10/2020 | USD | 1.173 |
| 02/10/2020 | BGN | 1.9558 |
| 02/10/2020 | AUD | 1.6372 |
| 05/10/2020 | USD | 1.1768 |
| 05/10/2020 | BGN | 1.9558 |
| 05/10/2020 | AUD | 1.6379 |
| 06/10/2020 | USD | 1.1795 |
| 06/10/2020 | BGN | 1.9558 |
| 06/10/2020 | AUD | 1.6472 |
| Date | currency | rate |
| 01/10/2020 | USD | 1.1752 |
| 01/10/2020 | BGN | 1.9558 |
| 01/10/2020 | AUD | 1.6319 |
| 01/10/2020 | EUR | 1 |
| 02/10/2020 | USD | 1.173 |
| 02/10/2020 | BGN | 1.9558 |
| 02/10/2020 | AUD | 1.6372 |
| 02/10/2020 | EUR | 1 |
| 05/10/2020 | USD | 1.1768 |
| 05/10/2020 | BGN | 1.9558 |
| 05/10/2020 | AUD | 1.6379 |
| 05/10/2020 | EUR | 1 |
| 06/10/2020 | USD | 1.1795 |
| 06/10/2020 | BGN | 1.9558 |
| 06/10/2020 | AUD | 1.6472 |
| 06/10/2020 | EUR | 1 |
