Dummy output tabs

Question

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.

DateQualityFruit/VegetableColour01-MayHighAppleRed02-MayMediumOrangeOrange03-MayHighGrapesGreen04-MayHighWatermelonRed05-MayLowMangoYellow06-MayMediumPineappleYellow07-MayHighKiwiGreen08-MayMediumPotatoBrown09-MayLowTomatoRed10-MayHighSpinachGreen

RedOrangeGreenYellowBrownColourlessBaselessAbstract

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?

DateQualityFruit/VegetableColour01-MayHighAppleRed02-MayMediumOrangeOrange03-MayHighGrapesGreen04-MayHighWatermelonRed05-MayLowMangoYellow06-MayMediumPineappleYellow07-MayHighKiwiGreen08-MayMediumPotatoBrown09-MayLowTomatoRed10-MayHighSpinachGreen

Thank You

griseldagomes · Answer

@binu_acs Apologies for the delayed response. Is there any other way of sequencing the pivots one below the other as defining set space (area) for each pivot would not be correct as it could vary.

binu_acs · Answer

@griseldagomes One way of doing this

Colors_090523.yxmd