Spreadsheet: 87633d1287514211-data-sorting-grouping-function-sample-for-excel-forum
Sheet: Sample

A03 Learner Ref Number | A09 Learning Aim Ref | Learning_Aim_Title | A26 Framework Code | A15 Programme Type | A27 Learning Start Date | A28 Learning Planned End Date | A31 Learning Actual End Date | L09 | L10
4056761 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-02-22 00:00:00 | 2010-09-30 00:00:00 | 2010-07-14 00:00:00 | Hoyle | Kerry
4056761 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
4056761 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
4056761 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 | 2010-02-11 00:00:00 | Hoyle | Kerry
4056761 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
21022464 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-02-09 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | Anne-Marie
21022464 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | Anne-Marie
21022464 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | Anne-Marie
21022464 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-01-20 00:00:00 | [NAME] | Anne-Marie
21022464 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | Anne-Marie
21022945 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-01-20 00:00:00 | 2010-09-30 00:00:00 | 2010-08-04 00:00:00 | Cobourn | [NAME]
21022945 | 10002832 | Key Skills in Application of Number - level 2 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | Cobourn | [NAME]
21022945 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | Cobourn | [NAME]
21022945 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2009-11-24 00:00:00 | Cobourn | [NAME]
21022945 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-08-04 00:00:00 | Cobourn | [NAME]
21024311 | 10050942 | NVQ in Wood Occupations | 116 | 3 | 2008-01-19 00:00:00 | 2009-09-18 00:00:00 | 2009-12-02 00:00:00 | [NAME] | [NAME]
21024311 | 10002856 | Key Skills in Application of Number - level 1 | 116 | 3 | 2008-01-19 00:00:00 | 2009-09-18 00:00:00 | 2010-01-30 00:00:00 | [NAME] | [NAME]
21024311 | 1000287X | Key Skills in Communication - level 1 | 116 | 3 | 2008-01-19 00:00:00 | 2009-09-18 00:00:00 | 2010-01-30 00:00:00 | [NAME] | [NAME]
21024311 | 10012540 | Construction Award | 116 | 3 | 2008-01-19 00:00:00 | 2009-09-18 00:00:00 | 2009-08-11 00:00:00 | [NAME] | [NAME]
21024311 | ZPROG001 | Generic code to identify ILR programme aims | 116 | 3 | 2008-01-19 00:00:00 | 2009-09-18 00:00:00 | 2010-01-30 00:00:00 | [NAME] | [NAME]
22014158 | 10002856 | Key Skills in Application of Number - level 1 | 116 | 3 | 2008-09-08 00:00:00 | 2009-09-30 00:00:00 | 2009-08-01 00:00:00 | Walker | [NAME]
22014158 | 1000287X | Key Skills in Communication - level 1 | 116 | 3 | 2008-09-08 00:00:00 | 2009-09-30 00:00:00 | 2009-08-01 00:00:00 | Walker | [NAME]
22014158 | 50030620 | NVQ in Plastering (Construction) | 116 | 3 | 2008-09-08 00:00:00 | 2009-09-30 00:00:00 | 2009-03-26 00:00:00 | Walker | [NAME]
22014158 | 10012540 | Construction Award | 116 | 3 | 2008-09-08 00:00:00 | 2009-09-30 00:00:00 | 2009-08-11 00:00:00 | Walker | [NAME]
22014158 | ZPROG001 | Generic code to identify ILR programme aims | 116 | 3 | 2008-09-08 00:00:00 | 2009-09-30 00:00:00 | 2009-08-11 00:00:00 | Walker | [NAME]
22027162 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-06-02 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | [NAME]
22027162 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | [NAME]
22027162 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | [NAME]
22027162 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-01-20 00:00:00 | [NAME] | [NAME]
22027162 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | [NAME]
22037521 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2009-12-04 00:00:00 | 2010-09-30 00:00:00 | 2010-01-18 00:00:00 | [NAME] | [NAME]
22037521 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-01-18 00:00:00 | [NAME] | [NAME]
22037521 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-01-18 00:00:00 | [NAME] | [NAME]
22037521 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-01-18 00:00:00 | [NAME] | [NAME]
22037521 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-01-18 00:00:00 | [NAME] | [NAME]
23044552 | 10002832 | Key Skills in Application of Number - level 2 | 117 | 3 | 2009-09-14 00:00:00 | 2011-09-30 00:00:00 |  | Garabet | Huseyin
23044552 | 10002881 | Key Skills in Communication - level 2 | 117 | 3 | 2009-09-14 00:00:00 | 2011-09-30 00:00:00 | 2010-08-09 00:00:00 | Garabet | Huseyin
23044552 | 10032848 | NVQ in Mechanical Engineering Services - Plumbing | 117 | 3 | 2009-12-08 00:00:00 | 2011-09-30 00:00:00 |  | Garabet | Huseyin
23044552 | 10033567 | Certificate in Basic Plumbing Studies | 117 | 3 | 2009-09-14 00:00:00 | 2011-09-30 00:00:00 |  | Garabet | Huseyin
23044552 | ZPROG001 | Generic code to identify ILR programme aims | 117 | 3 | 2009-09-14 00:00:00 | 2011-09-30 00:00:00 |  | Garabet | Huseyin
23048536 | 10045788 | NVQ for IT Practitioners | 360 | 3 | 2009-09-14 00:00:00 | 2011-03-31 00:00:00 | 2009-10-15 00:00:00 | Hall | [NAME]
23048536 | 10002856 | Key Skills in Application of Number - level 1 | 360 | 3 | 2009-09-14 00:00:00 | 2011-03-31 00:00:00 | 2009-10-15 00:00:00 | Hall | [NAME]
23048536 | 1000287X | Key Skills in Communication - level 1 | 360 | 3 | 2009-09-14 00:00:00 | 2011-03-31 00:00:00 | 2009-10-15 00:00:00 | Hall | [NAME]
23048536 | ZPROG001 | Generic code to identify ILR programme aims | 360 | 3 | 2009-09-14 00:00:00 | 2011-03-31 00:00:00 | 2009-10-15 00:00:00 | Hall | [NAME]
23049699 | 10002832 | Key Skills in Application of Number - level 2 | 117 | 3 | 2008-09-08 00:00:00 | 2010-09-30 00:00:00 | 2010-01-06 00:00:00 | [NAME] | [NAME]
23049699 | 10002881 | Key Skills in Communication - level 2 | 117 | 3 | 2008-09-08 00:00:00 | 2010-09-30 00:00:00 | 2010-01-06 00:00:00 | [NAME] | [NAME]
23049699 | 10032848 | NVQ in Mechanical Engineering Services - Plumbing | 117 | 3 | 2008-11-27 00:00:00 | 2010-09-30 00:00:00 | 2010-01-06 00:00:00 | [NAME] | [NAME]
23049699 | 10033567 | Certificate in Basic Plumbing Studies | 117 | 3 | 2008-09-08 00:00:00 | 2010-09-30 00:00:00 | 2010-01-06 00:00:00 | [NAME] | [NAME]
23049699 | ZPROG001 | Generic code to identify ILR programme aims | 117 | 3 | 2008-09-08 00:00:00 | 2010-09-30 00:00:00 | 2010-01-06 00:00:00 | [NAME] | [NAME]
24075162 | 10002856 | Key Skills in Application of Number - level 1 | 116 | 3 | 2007-09-13 00:00:00 | 2009-09-12 00:00:00 | 2010-01-30 00:00:00 | Hart | [NAME]
24075162 | 1000287X | Key Skills in Communication - level 1 | 116 | 3 | 2007-09-13 00:00:00 | 2009-09-12 00:00:00 | 2010-01-30 00:00:00 | Hart | [NAME]
24075162 | 10051168 | NVQ in Decorative Finishing and Industrial Painting Occupations | 116 | 3 | 2007-09-13 00:00:00 | 2009-09-12 00:00:00 | 2009-08-11 00:00:00 | Hart | [NAME]
24075162 | 10012540 | Construction Award | 116 | 3 | 2007-09-13 00:00:00 | 2009-09-12 00:00:00 | 2009-08-11 00:00:00 | Hart | [NAME]
24075162 | ZPROG001 | Generic code to identify ILR programme aims | 116 | 3 | 2007-09-13 00:00:00 | 2009-09-12 00:00:00 | 2010-01-30 00:00:00 | Hart | [NAME]