Spreadsheet: 850130d1700508793-pulling-data-from-disparate-columns-unique-filter
Sheet: All the Data, need to arrange

 |  | EmplID | Name | [NAME] | Job Title | Salary | Reports To Name | PAC Code | Cost Pool Down MFR Strategy
 | 00087126 | [PHONE] | Archie | 00AAC00000 | Administrative Asst II | 2824.57 | [NAME] | 41200 | D.1.2 |  | My formula pulls all the data, but I need to filter out the VACANTs in D
 | 00037879 | 0 | Vacant | 00AAC00000 | Administrative Assistant V | 4012.5 | [NAME] | 41200 | D.1.2 |  | Also need to rearrange the columns in this order:
 | 00115804 | [PHONE] | [NAME] | 00AAC00000 | Project Manager III | 6941.5 | [NAME] the son of Zebedee | 41903 | D.1.2 |  | Cost Pool Down MFR Strategy | [NAME] | PAC Code | EmplID | Name | Position | Job Title | Reports To Name | Salary
 | 00088961 | [PHONE] | Veronica | 00AAC00000 | Project Manager IV | 9750 | [NAME] | 41903 | D.1.2
 | 00089575 | [PHONE] | Betty | 00AAC00000 | Project Manager IV | 9466.96 | [NAME] | 41905 | D.1.2
 | 00115660 | [PHONE] | Kalel | 00AAC00000 | Project Manager IV | 9560.1 | Bartholomew | 41905 | D.1.2
 | 00116132 | [PHONE] | Superman | 00AAC00000 | Project Manager IV | 8644.31 | [NAME] | 41905 | D.1.2
 | 00037888 | 0 | Vacant | 00AAC00000 | Manager IV | 8078.79 | [NAME] | 41200 | D.1.2
 | 00116198 | 0 | Vacant | 00AAC00000 | Manager IV | 8078.79 | [NAME] the son of [NAME] | 41200 | D.1.2
 | 00060423 | [PHONE] | Spiderman | 00AAC00000 | Director III | 8333.33 | Thaddaeus | 41200 | D.1.2
 | 00060441 | [PHONE] | [NAME] | 00AAC00000 | Director III | 8412.49 | [NAME] the Zealot | 41200 | D.1.2
 | 00028431 | [PHONE] | [NAME] | 00AAC00000 | Director V | 12537.86 | [NAME] | 41200 | D.1.2
 | 00038527 | [PHONE] | [NAME] | 00ADDPGS00 | Program Specialist VI | 5639.36 | [NAME] the son of [NAME] | 41200 | D.1.2
 | 00087127 | 0 | Vacant | 00ADDPGS00 | Program Specialist VI | 5655.59 | Thaddaeus | 41200 | D.1.2
 | 00037873 | [PHONE] | Micky | 00APP00000 | Quality Assurance Spec IV | 6201.19 | [NAME] the Zealot | 41200 | D.1.2
 | 00059998 | [PHONE] | Minnie | 00APP00000 | Quality Assurance Spec IV | 4720.27 | [NAME] | 41200 | D.1.2
 | 00060000 | [PHONE] | [NAME] | 00APP00000 | Quality Assurance Spec IV | 5687.32 | [NAME] | 41200 | D.1.2
 | 00060001 | [PHONE] | Goofy | 00APP00000 | Quality Assurance Spec IV | 5743.74 | [NAME] | 41200 | D.1.2
 | 00060002 | [PHONE] | Dopey | 00APP00000 | Quality Assurance Spec IV | 4705.2 | [NAME] the son of Zebedee | 41200 | D.1.2
 | 00087128 | [PHONE] | Doc | 00APP00000 | Quality Assurance Spec IV | 5816.01 | [NAME] | 41200 | D.1.2
 | 00037875 | [PHONE] | Grumpy | 00APP00000 | Program Specialist VI | 5931.32 | [NAME] | 41200 | D.1.2
 | 00038413 | [PHONE] | [NAME] | 00APP00000 | Program Specialist VI | 5196.42 | Bartholomew | 41200 | D.1.2
 | 00078932 | [PHONE] | Sleepy | 00APP00000 | Program Specialist VI | 5165.75 | [NAME] | 41200 | D.1.2
 | 00086425 | [PHONE] | Bashful | 00APP00000 | Program Specialist VI | 5666.63 | [NAME] | 41200 | D.1.2
 | 00037881 | 0 | Vacant | 00APP00000 | Program Specialist VII | 6241.66 | [NAME] the son of [NAME] | 41200 | D.1.2
 | 00039073 | [PHONE] | [NAME] | 00APP00000 | Program Specialist VII | 6008.66 | Thaddaeus | 41200 | D.1.2
 | 00041602 | [PHONE] | Batman | 00APP00000 | Manager V | 6354.37 | [NAME] the Zealot | 41200 | D.1.2
 | 00060422 | [PHONE] | [NAME] | 00APP00000 | Manager V | 6560.61 | [NAME] | 41200 | D.1.2
 | 00037885 | [PHONE] | [NAME] | 00APS00001 | Research Specialist V | 6720 | [NAME] | 41200 | D.1.2
 | 00038152 | 0 | Vacant | 00APS00001 | Project Manager III | 6067.63 | [NAME] | 41200 | D.1.2
 | 00089654 | 0 | Vacant | 00APS00001 | Project Manager III | 7083 | [NAME] the son of Zebedee | 41903 | D.1.2
 | 00037882 | 0 | Vacant | 00APS00001 | Program Specialist VI | 6775.24 | [NAME] | 41200 | D.1.2
 | 00037877 | [PHONE] | Ringo | 00APS00001 | Program Specialist VII | 6841.23 | [NAME] | 41200 | D.1.2
 | 00087129 | [PHONE] | [NAME] | 00APS00001 | Manager V | 6917.09 | Bartholomew | 41200 | D.1.2
 | 00039072 | [PHONE] | [NAME] | 00APS00001 | Director I | 7173.76 | [NAME] | 41200 | D.1.2
 | 00059035 | [PHONE] | [NAME] | 01ADDINH00 | Program Specialist V | 6300.06 | [NAME] | 41000 | D.1.1
 | 00079006 | [PHONE] | [NAME] | 01ADDINH00 | APS Program Administ | 6398.67 | [NAME] the son of [NAME] | 41000 | D.1.1
 | 00060076 | [PHONE] | [NAME] | 01ADDINH00 | APS INV Specialist V | 4929.55 | Thaddaeus | 41000 | D.1.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