Alteryx Table formatting

[davidogundipe]

When creating excel pivot table-like structures in alteryx, it is possible to make tables appear like the table in the screenshot instead of the table here? I don't want to have too many repeated rows. Please let me know if this is possible. Thanks!

Fruit	Apple
Fruit	Orange
Vegetable	Carrot
Vegetable	Broccoli

[DeanWest]

Unfortunately, I do not believe that type of functionality is supported in Alteryx. Since each record is separate, you can not "merge" the records in groups as you can in Excel. You could create different fields that could contain the individual values you listed or create a null value after the first appearance of the first field to create somewhat of the same visual effect. 

This could be accomplished using the Table tool in the report category so that null values appear as white cells. Although the values with be located near the top and not the middle like you requested in your example. 

[Qiu]

@davidogundipe 
Note 100% as you need, but maybe you can give it a go.