Extracting a value from a cell within a column depending on a value within its row

[Gunex89]

Hi guys,

Starting off with this table below:

Apt #	Room 1	Room 2	Room 3
A-G01	ARXD09GALH	ARTG09LLTA	ARTG09LLTA
B-G12			ARXD18GALH
D-G33	ARTG09LLTA	ARTG09LLTA

<tbody>
</tbody>

I want to make a table which lists the Apartment numbers (Apt #) for each model type (there are three model types here; ARXD09GALH, ARTG09LLTA and ARXD18GALH). Thus I need three tables:

ARXD09GALH

A-G01

<tbody>
</tbody>

ARTG09LLTA

A-G01

D-G33

<tbody>
</tbody>

ARXD18GALH

B-G12

<tbody>
</tbody>

Thank you in advance,

Keith

 

[deletedalien]

how can apt. A-G01 be 2 model types?

 

[Gunex89]

how can apt. A-G01 be 2 model types?

There are two types of fan coil units in apartment A-G01..

anyone?