Spreadsheet: 69422d1269955154-a-very-complicated-deleting-of-duplicates-example
Sheet: Sheet1

FROM THIS:
ID | Business Area | Request Type | Project | Project Manager | Project Status | Stage | Stage2 | Planview ID | Role | Sub-Role | Employment Type | Requested Name | Location | Process | [NAME] | Specialism | From | To | Full Time Equivalent | % Effort | Comments | Name | Status
1 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-04-25 00:00:00 | 2010-05-23 00:00:00 | 1 | 100 |  | [NAME] | H
2 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-05-24 00:00:00 | 2010-08-01 00:00:00 | 1 | 100 |  | [NAME] | H
3 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-08-02 00:00:00 | 2010-10-17 00:00:00 | 1 | 100 |  | [NAME] | H
4 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-10-18 00:00:00 | 2010-11-28 00:00:00 | 1 | 100 |  | [NAME] | H
5 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-11-29 00:00:00 | 2011-03-06 00:00:00 | 1 | 100 |  | [NAME] | H
6 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2011-03-07 00:00:00 | 2011-05-01 00:00:00 | 1 | 100 |  | [NAME] | H
7 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2011-04-25 00:00:00 | 2012-05-01 00:00:00 | 1 | 100 |  | [NAME] | H
8 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-02-25 00:00:00 | 2010-05-23 00:00:00 | 1 | 100 |  | [NAME] | H
9 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-07-24 00:00:00 | 2010-08-01 00:00:00 | 1 | 100 |  | [NAME] | H
10 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-01-02 00:00:00 | 2010-10-17 00:00:00 | 1 | 100 |  | [NAME] | H
11 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-10-18 00:00:00 | 2010-11-28 00:00:00 | 1 | 100 |  | [NAME] | H
12 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-11-29 00:00:00 | 2013-03-06 00:00:00 | 1 | 100 |  | [NAME] | H
13 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2011-03-07 00:00:00 | 2011-05-01 00:00:00 | 1 | 100 |  | [NAME] | H
14 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2012-04-25 00:00:00 | 2012-05-01 00:00:00 | 1 | 100 |  | [NAME] | H
TO THIS:
ID | Business Area | Request Type | Project | Project Manager | Project Status | Stage | Stage2 | Planview ID | Role | Sub-Role | Employment Type | Requested Name | Location | Process | [NAME] | Specialism | From | To | Full Time Equivalent | % Effort | Comments | Name | Status
1 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 1 | [NAME] | [NAME] | W | [NAME] | UK | Business | Cleaning | Cleaning | 2010-04-25 00:00:00 | 2012-05-01 00:00:00 | 1 | 100 |  | [NAME] | H
10 | X | Y | Z | [NAME] | Open/Active | Select | Plan | 2 | Builder | Builder | W | [NAME] | UK | Business | Builder | Builder | 2010-01-02 00:00:00 | 2013-03-06 00:00:00 | 1 | 100 |  | [NAME] | H