Spreadsheet: 716779d1612361664-eliminate-duplicate-text-eliminate-duplicate-text-question
Sheet: Sheet1

 |  |  |  |  | Results Required |  |  | PIVOT TABLE
Pete_UK | Room | Spec Tag | [NAME] |  | CHEMISTB
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | Spec Tag | [NAME]
 | co-working area | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | AMT-105 | PPC metal ceiling by lift manufacturer
 | reception | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | CLG-22 | Dulux Trade Vinyl Matt
 | reception | CLG-30 A | Feature timber ceiling |  |  |  |  | CLG-30 A | Cube acoustic panel by Autex Acoustics Ltd.
 | reception | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd. |  |  |  |  | CLG-30 A | Feature timber ceiling
 | residents' lounge | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | residents' lounge | CLG-30 A | Feature timber ceiling |  |  |  |  | CLG-30 B | Feature timber ceiling
 | residents' lounge | CLG-30 A | Cube acoustic panel by Autex Acoustics Ltd. |  |  |  |  | CLG-30 C | Feature timber ceiling
 | workstations | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | CLG-40 | Cube acoustic panel by Autex Acoustics Ltd.
 | workstations | FIN-155 | Dulux Trade Vinyl Matt |  | Bo_Ry |  |  | FIN-155 | Dulux Trade Vinyl Matt
 | workstations | FIN-155 | Dulux Trade Vinyl Matt |  |  |  |  | FIN-801 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | screening room | CLG-40 | Cube acoustic panel by Autex Acoustics Ltd.
 | Staff Shower/ WC | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | staff room | FIN-155 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | post room | FIN-155 | Dulux Trade Vinyl Matt
 | mail room | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt |  | [NAME]
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | dog wash | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | yoga room | CLG-22 | Dulux Trade Vinyl Matt
 | gym | CLG-22 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | playspace | CLG-22 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt |  | [NAME]
 | core 01 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 01 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 02 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 03 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | CLG-30 B | Feature timber ceiling
 | residents lounge | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | games | FIN-155 | Dulux Trade Vinyl Matt
 | games | CLG-30 B | Feature timber ceiling |  | CK76
 | games | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC lobby | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | lounge/ library | FIN-801 | Dulux Trade Vinyl Matt |  |  |  | <--Add IFERROR to remove #N/A
 | lounge/ library | CLG-30 C | Feature timber ceiling
 |  |  |  |  | Pete_UK