V
Vinnie_AD
I have data that looks like this…
Openings Qty Location 1
100 1 STAIR
101 1 EXTERIOR
102 1 CORRIDOR
103 1 STAIR
104 1 EXTERIOR
105 1 CORRIDOR
106 1 CORRIDOR
107 1 CORRIDOR
108 1 CORRIDOR
109 1 CORRIDOR
110 1 DINING
That I want to query like this…
2 STAIR 100. 103
2 EXTERIOR 101, 104
6 CORRIDOR 102, 105, 106, 107, 108, 109
1 DINING 110
Can you help?
Openings Qty Location 1
100 1 STAIR
101 1 EXTERIOR
102 1 CORRIDOR
103 1 STAIR
104 1 EXTERIOR
105 1 CORRIDOR
106 1 CORRIDOR
107 1 CORRIDOR
108 1 CORRIDOR
109 1 CORRIDOR
110 1 DINING
That I want to query like this…
2 STAIR 100. 103
2 EXTERIOR 101, 104
6 CORRIDOR 102, 105, 106, 107, 108, 109
1 DINING 110
Can you help?