Count of variables in multigrouping

[ievpal]

Hi everyone,

I haven`t been able to solve this problem for a few days now. I have a data set that needs to be grouped and have the count of how many times this variable appeared in this group as shown bellow. However, everytime I try to group these variables and when I try to find the count of these variable I can only find a right count for Var1.

Sample input data set:

Required result:

Thank you.

[pcatterson]

I believe what you want to do is a series of summaries and subsequent joins.  Is this what you were looking for?

[ievpal]

Thank you. It`s more than I had.

But it would still be very nice to have Var1 mentioned only once, like we can have in pivot tables. Is that even possible? :)

[pcatterson · Accepted solution]

You can make the duplicates NULL but there isn't a way to merge cells like you've visualized.  That would be applying a hierarchy to the data.