Question: Concise List

Hello,

I have a list of rooms in Col. A and a List of devices in Col. C and time used in Col. F.

I have a list of unique rooms in Col. I and unique devices in Col. J.

Col A:
AE137
AE137
AE137
AE137
AE137

Col. C:

Projector
Blank
Blank
Desktop
Laptop

I would like a concise list of Rooms, Devices and Times used:

AE137, Projector, time used, Desktop, time used, Lap top, time used.

Is it possible?

Thank you,

Stephanie

Thank you.