Spreadsheet: 867538d1714389163-moving-specific-data-from-rows-to-columns-sample
Sheet: Sample data

Parent Client Name | Client Number | Client Grade | Grade | Office | Rates type | Currency | Hourly Rates | Agreement term | Start Date | End Dates | Renewal alert | Pricing team reviewed (Y/N) | Date of pricing discussion | Live rates (Y/N) | New rates agreed (Y/N) | Renewal alert in the future (T/F) | Expired rates | Volume discount mechanism (Y/N) | Rebate | Credit | Discount %
Client 1 | 123456 |  | Equity Partner Premium Rates | London | 3rd Party | GBP | 710.5 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Equity Partner | London | 3rd Party | GBP | 710.5 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Fixed Equity Partner 3 years + | London | 3rd Party | GBP | 613 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Fixed Equity Partner | London | 3rd Party | GBP | 613 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Consultant | London | 3rd Party | GBP |  | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Of Counsel | London | 3rd Party | GBP | 582 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 4 | London | 3rd Party | GBP | 551 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 3 | London | 3rd Party | GBP | 551 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 2 | London | 3rd Party | GBP | 551 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 1 | London | 3rd Party | GBP | 551 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 3 | London | 3rd Party | GBP | 515 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 2 | London | 3rd Party | GBP | 515 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 1 | London | 3rd Party | GBP | 515 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 3 | London | 3rd Party | GBP | 418 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 2 | London | 3rd Party | GBP | 418 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 1 | London | 3rd Party | GBP | 418 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Trainee | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Legal Assistant | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Legal Exec | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | [NAME] Analyst | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Paralegal Senior | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Paralegal | London | 3rd Party | GBP | 202 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Equity Partner Premium Rates | Paris | 3rd Party | EUR | 657 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Equity Partner | Paris | 3rd Party | EUR | 657 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Fixed Equity Partner 3 years + | Paris | 3rd Party | EUR | 657 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Fixed Equity Partner | Paris | 3rd Party | EUR | 657 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Consultant | Paris | 3rd Party | EUR |  | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Of Counsel | Paris | 3rd Party | EUR | 576 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 4 | Paris | 3rd Party | EUR | 546 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 3 | Paris | 3rd Party | EUR | 546 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 2 | Paris | 3rd Party | EUR | 546 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Senior 1 | Paris | 3rd Party | EUR | 546 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 3 | Paris | 3rd Party | EUR | 484 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 2 | Paris | 3rd Party | EUR | 484 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Mid 1 | Paris | 3rd Party | EUR | 484 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 3 | Paris | 3rd Party | EUR | 384 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 2 | Paris | 3rd Party | EUR | 384 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Junior 1 | Paris | 3rd Party | EUR | 384 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Trainee | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Legal Assistant | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Legal Exec | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | [NAME] Analyst | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Paralegal Senior | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N
Client 1 | 123456 |  | Paralegal | Paris | 3rd Party | EUR | 218 | 35 months | 2024-04-01 00:00:00 | 2027-03-31 00:00:00 | 2026-09-30 00:00:00 | Y | 2023-06-01 00:00:00 | Y | Y | True | N | N | N | N | N