How to make document to be displayed twice in same view?

I want to create a view, but same document will have two different categories, and one will be displayed on top (via sortingkey 1) , the other one will be displayed below (via sorting key 9). the the data is from one same document. I know there is selection to displayed multiple value into same view, but this can only have the same document being displayed one after another right? i.e not with another document being displayed in the middle? or other applications, like export to excel or link to crystal reporting is a better option?

Subject: Unless I am misunderstanding your question, the view will do exactly what you want.

For example. If I create 3 documents, and assign each multiple categories…

Then they show up under the correct category, not right after each other. See document 1 below

Alan Lepofsky - IBM/Lotus

Learn more at my Lotus Notes Tips and Tricks Blog

LOTs of US working together to innovate for success

Subject: RE: Unless I am misunderstanding your question, the view will do exactly what you want.

Tq, Alan, really appreciates it. I am impress how you are able to paste with pictures, it really helps in my work.