pivot columns like straight table

[#1]

Hello

I have this situation in a Pivot table:

HouseName, Products, COSTS

A        CHEESE      2

           BLALGLA     4

          JSDOASJD      4

          SJDASDJ     5

B       HEHEHE      2

          UHLHLA      2

And so on.

How can i do so i would be like this, and i also want to remove my Sum column, I know i cannot hide columns, but can i show the dimensions without having an expression?:

HouseName

     A                         B

CHEESE               HEHEHE    

BLABLGA          UHLHLA     

Or is it possible in a straight table??

[Gysbert_Wassenaar]

See attached qvw for two options.

[#3]

Cheers! Do you know if it is possible to change the cell height for only the products?

If i turn of the cell height to example 20. Both will be 20, and then there will be a lot of white space.

And how do i make an autonumber if my Cost is coming from another table?

[#4]

Sorry i corrected your answer - can you maybe tell me how to fix what i wrote in my message before this post?