Show all values in matrix or create a pivot table

[Anonymous]

Hello,

First of all, here's my data:

Category	Period	Content
Category 1	Q4 2023	UniqueValue1
Category 1	Q4 2023	UniqueValue2
Category 1	Q4 2023	UniqueValue3
Category 1	Q4 2023	UniqueValue4
Category 2	Q3 2023	UniqueValue5
Category 2	Q4 2023	UniqueValue6
Category 2	Q4 2023	UniqueValue7
Category 2	Q4 2023	UniqueValue8

I have this table and I would like to know if there's a way to bypass and list all the items having:

- Category column in rows

- Period in columns

- Content in values

My problem here is that values only take either first or last value hence, I cannot display all of the items.

One thing that I'm looking at and if it is possible is to do pivot resulting in this table: 

Category	Q3 2023	Q4 2023
Category 1		UniqueValue1 UniqueValue2 UniqueValue3 UniqueValue4
Category 2	UniqueValue5	UniqueValue6 UniqueValue7 UniqueValue8

Any help and assistance with be appreciated, thank you

[amitchandak]

@Anonymous , If you need every thing in row , you can use Table, but if you want a field on the column you use a matrix

You can do some conditional formatting on table to change report look

https://youtu.be/C9K8uVfthUU

But you have used field or row/column if you do not want to summarize