6diegodiego9
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 80
- Office Version
- 2016
- Platform
- Windows
I've an Excel range like the following, with merged cells and many dates (3 years):
How can I transform it for use with Power Charts? i.e. repeating the missing Brand and Model values and taking all the dates as as a Date field
| Brand | Model | Color | 01/01/2022 | 02/01/2022 | 03/01/2022 | 04/01/2022 |
| Tesla | X | Red | 4 | 5 | 6 | 1 |
| Blue | 8 | 3 | 2 | 7 | ||
| S Plaid | Red | 5 | 1 | 3 | 2 | |
| Opel | Zafira | Yellow | 8 | 7 | 7 | 3 |
| Corsa | Green | 8 | 4 | 4 | 2 | |
| White | 3 | 2 | 1 | 1 | ||
How can I transform it for use with Power Charts? i.e. repeating the missing Brand and Model values and taking all the dates as as a Date field
