Hello Experts,
I have 2 queries:
1. I have the segregated the below set of data into multiple tabs in the output file based on 'Colour' field.
However, in addition to the 5 colour tabs, I need 3 additional tabs with the same headers as each colour tab, however the data would be blank.
Could you please advise how can I achieve this.
| Date | Quality | Fruit/Vegetable | Colour |
| 01-May | High | Apple | Red |
| 02-May | Medium | Orange | Orange |
| 03-May | High | Grapes | Green |
| 04-May | High | Watermelon | Red |
| 05-May | Low | Mango | Yellow |
| 06-May | Medium | Pineapple | Yellow |
| 07-May | High | Kiwi | Green |
| 08-May | Medium | Potato | Brown |
| 09-May | Low | Tomato | Red |
| 10-May | High | Spinach | Green |
| Red | Orange | Green | Yellow | Brown | Colourless | Baseless | Abstract |
2. I have to create 2 pivots - one of the 'count of quality' and second on the 'count of Fruit/Vegetable' for the below data set and I have to place both the pivots one below the other in a new tab. Is this possible?
| Date | Quality | Fruit/Vegetable | Colour |
| 01-May | High | Apple | Red |
| 02-May | Medium | Orange | Orange |
| 03-May | High | Grapes | Green |
| 04-May | High | Watermelon | Red |
| 05-May | Low | Mango | Yellow |
| 06-May | Medium | Pineapple | Yellow |
| 07-May | High | Kiwi | Green |
| 08-May | Medium | Potato | Brown |
| 09-May | Low | Tomato | Red |
| 10-May | High | Spinach | Green |
Thank You
