Group events by mutiple fields

[DeXteR]

Hi I have some events in splunk which are of this form-

Location: some value(same value can be there in multiple events)

Client: some value(same value can be there in multiple events)

TransactionNumber: some value(Unique for each event)

Transaction Time: some value(Unique for each event)

Now I want a table in this form -

Screenshot 2020-09-01 at 8.22.58 PM.png

Basically each location can have multiple clients and each client can have different transactions. Transaction number and transaction time are unique and have one to one mapping.

I am using this query in splunk-

| stats list(TransactionNumber) list(TransactionTime) by Location Client

What's happening is I am getting unique combination of location and client but what I want is unique clients to be listed against a particular Location.

This is what i am getting-

Screenshot 2020-09-01 at 8.24.06 PM.png

How can the query be modified to achieve the same?

[richgalloway]

The only difference I see is the empty cells in the Location field.  Is there something else?

[DeXteR]

Yes