Hello everybody,
Let's say I have an Excel file similar to this:
| blablalbllb | blabla | bla blaaaa | | |
| bla bla bla bla | bla bla bla | | | |
| Date | Tea | Coffee | Soda | Water |
| 2020/11 | 12 | 35 | 7 | 81 |
| 2020/12 | 15 | 33 | 9 | 81 |
I'd like to remove the first two rows and set the third one as a header's row.
I managed to use the sample tool and skip 2 rows, but instead of having this:
| Date | Tea | Coffee | Soda | Water |
| 2020/11 | 12 | 35 | 7 | 81 |
| 2020/12 | 15 | 33 | 9 | 81 |
I have this:
| F1 | F2 | F3 | F4 | F5 |
| Date | Tea | Coffee | Soda | Water |
| 2020/11 | 12 | 35 | 7 | 81 |
| 2020/12 | 15 | 33 | 9 | 81 |
Why is that?
Could you help me please? Thanks!