Spreadsheet: 866324d1713277120-looking-for-a-way-convert-horizontal-data-into-vertical-clusters-based-on-unique-value-unit-mapping-file
Sheet: Datasheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
A/A | Mapping | Property Code | [NAME] (SQM) |  |  |  |  |  | Mezzanine (SQM) |  |  |  |  |  | 1st Floor (SQM) |  |  |  |  |  | 2nd Floor(SQM) |  |  |  |  |  | 3rd Floor (SQM) |  |  |  |  |  | 4th Floor (SQM) |  |  |  |  |  | 5th Floor (SQM) |  |  |  |  |  | 6th Floor (SQM) |  |  |  |  |  | 7th Floor (SQM) |  |  |  |  |  | 8th [NAME] (SQM) |  |  |  |  |  | 9th Floor (SQM) |  |  |  |  |  | 10th Floor (SQM) |  |  |  |  |  | 11th Floor (SQM) |  |  |  |  |  | 12th [NAME] (SQM) |  |  |  |  |  | 13th [NAME] (SQM) |  |  |  |  |  | 14th Floor (SQM) |  |  |  |  |  | 15th Floor (SQM) |  |  |  |  |  | 16th Floor (SQM) |  |  |  |  |  | 17th Floor (SQM) |  |  |  |  |  | 18th [NAME] (SQM) |  |  |  |  |  | 19th [NAME] (SQM) |  |  |  |  |  | 1st Basement (SQM) |  |  |  |  |  | 1st Basement (Parking Spots) |  |  |  |  |  | 2nd Basement (SQM) |  |  |  |  |  | 2nd Basement (Parking Spots) |  |  |  |  |  | 3rd Basement (SQM) |  |  |  |  |  | 3rd Basement (Parking Spots) |  |  |  |  |  | 4th Basement (SQM) |  |  |  |  |  | 4th Basement (Parking Spots) |  |  |  |  |  | 5th Basement (SQM) |  |  |  |  |  | 5th Basement (Parking Spots) |  |  |  |  |  | 6th Basement (SQM) |  |  |  |  |  | 6th Basement (Parking Spots) |  |  |  |  |  | Attic (SQM) |  |  |  |  |  | Storage Space |  |  |  |  |  | Semicovered Area |  |  |  |  |  | Passage Rights (NBG) |  |  |  |  |  | Ground Floor Parking (SQM) |  |  |  |  |  | Ground Floor Parking (Parking Spots) |  |  |  |  |  | Τραπεζάκια Ισογείου / Ράμπες |  |  |  |  |  | Covered [NAME] |  |  |  |  |  | Uncovered [NAME] |  |  |  |  |  | Total (SQM)
 |  |  | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels | Retail | Bank Branch | Office | Logistics | Other | Hotels
1 | 30056_tenant 1 | 30056 | 0 | 0 | 0 | 0 | 188 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 188 | 0
 | 30056_tenant 2 | 30076 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 495.53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 510.53 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 90.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1997.12 | 1577.34 | 0 | 0 | 0
 | 30056_tenant 3 | 30097 | 207.8 | 0 | 0 | 0 | 0 | 0 | 107.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 207.8 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 523 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0+EY10:FD10``