Alteryx Table formatting

Question

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!

FruitAppleFruitOrangeVegetableCarrotVegetableBroccoli

Qiu · Answer

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

1121-davidogundipe.yxmd

DeanWest · Answer

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.