How to group similar values in a Straight Table

[Anonymous]

So, instead of showing table A below, I want to format it like table B.

Thanks

Table A:  

Project ID	Submitted Item ID
123	Apple
123	Banana
123	Orange
123	Pear
456	Banana
456	Orange
456	Pear
456	Watermelon

Table B:  

Project ID	Submitted Item ID
123	Apple
	Banana
	Orange
	Pear
456	Banana
	Orange
	Pear
	Watermelon

[robert_mika · Accepted solution]

Create extra expression

Enter 1

Hide the Expression in presentation tab

In Dimensions under Text use

=if(RowNo()=1,Black(),White())

Feeling Qlikngry?

How To /Missing Manual(23 articles)

[sunny_talwar]

Awesome Robert

[Anonymous]

Smart Solution:)