Re-Arrange Linked Data Into Specific Cells

[ChuckRobert]

I have about 70 individual site wor<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:PersonName>kb</st1:PersonName>ooks that include a list of maintenance problems at that site. A Master wor<st1:PersonName>kb</st1:PersonName>ook links all maintenance problems to a dedicated sheet in 2 rows similar to this - <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Site Defect<o></o>
A Heating<o></o>
A Sink Leaking<o></o>
E Caulking<o></o>
F Heating<o></o>
F Caulking<o></o>
M Heating
<o></o>
<o></o>
What I what to learn is how to have the linked data grouped by Defect (first condition, second condition...(may vary)), and then have all Sites affected by that particular condition listed in the cell immediately to the right (Array?) in a dedicated range of cells (say G10:H20) on another sheet in my consolidated report. It would look like this:<o></o>
Defect Sites Affected<o></o>
Heating A, F, M<o></o>
Sink Leaking A<o></o>
Caulking E, F
<o></o>
<o></o>
I'd like to do this without a pivot chart. Any suggestions would be greatly appreciated!<o></o>