ARRANGING VALUES

[samxhander09]

Hi! Im trying to arrange my values to look like a table. 

Data looks like this:

How to arrange it to look like this under the below guide:

Group by Filename, this is important because filename has dates and we need to make sure all values will lined up on the correct date.

Group by Room #.

[gautiergodard · Accepted solution]

Hello @samxhander09 

I believe the attached is what you are looking for!

[samxhander09]

Exactly what I needed!! Thanks buddy!