Spreadsheet: 149817d1334153839-inserting-blank-lines-to-separate-data-based-on-one-of-the-column-contents-sample-insert-line
Sheet: Sheet1

RAW DATA
UNIT | OFFICE | LAST | FIRST | MI | EMP ID | SUB | ID NUMBER | JOB TITLE | PAY LEVEL | ID2 | FUNC | LDC | SECTION | HCES ORG NAME
CAMP | ATLANTA | SMITH | [NAME] | P | [NAME] | 22010 | 84464 | EMPLOYEE | 12 | GS | 1 | 17 | INSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | E | [NAME] | 20110 | 38819 | EMPLOYEE | 13 | GS | 1 | 18 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] |  | [NAME] | 20110 | 67911 | EMPLOYEE | 11 | GS | 1 | 18 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | D | [NAME] | 22110 | 91925 | EMPLOYEE | 8 | GS | 1 | 17 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | O | [NAME] | 22110 | 03072 | EMPLOYEE | 12 | GS | 1 | 17 | INSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | G | [NAME] | 28810 | 11754 | EMPLOYEE | 1 | GS | 1 | 13 | OUTSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | L | [NAME] | 28810 | 11770 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | H | [NAME] | 28810 | 54465 | EMPLOYEE | 12 | GS | 1 | 13 | INSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | M | [NAME] | 28810 | 54462 | EMPLOYEE | 12 | GS | 1 | 13 | OUTSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | Q | [NAME] | 28810 | 11755 | EMPLOYEE | 12 | GS | 1 | 13 | INSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | A | [NAME] | 28810 | 11697 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | H | [NAME] | 28810 | 11751 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | B | [NAME] | 28810 | 11775 | EMPLOYEE | 9 | GS | 1 | 13 | OUTSIDE | FIRST
WHAT I NEED
UNIT | OFFICE | LAST | FIRST | MI | EMP ID | SUB | ID NUMBER | JOB TITLE | PAY LEVEL | ID2 | FUNC | LDC | SECTION | HCES ORG NAME
CAMP | ATLANTA | SMITH | [NAME] | P | [NAME] | 22010 | 84464 | EMPLOYEE | 12 | GS | 1 | 17 | INSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | E | [NAME] | 20110 | 38819 | EMPLOYEE | 13 | GS | 1 | 18 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] |  | [NAME] | 20110 | 67911 | EMPLOYEE | 11 | GS | 1 | 18 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | D | [NAME] | 22110 | 91925 | EMPLOYEE | 8 | GS | 1 | 17 | OUTSIDE | COUNTER
CAMP | ATLANTA | SMITH | [NAME] | O | [NAME] | 22110 | 03072 | EMPLOYEE | 12 | GS | 1 | 17 | INSIDE | COUNTER
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
CAMP | ATLANTA | SMITH | [NAME] | G | [NAME] | 28810 | 11754 | EMPLOYEE | 1 | GS | 1 | 13 | OUTSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | L | [NAME] | 28810 | 11770 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | H | [NAME] | 28810 | 54465 | EMPLOYEE | 12 | GS | 1 | 13 | INSIDE | BACK
CAMP | ATLANTA | SMITH | [NAME] | M | [NAME] | 28810 | 54462 | EMPLOYEE | 12 | GS | 1 | 13 | OUTSIDE | BACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
CAMP | ATLANTA | SMITH | [NAME] | Q | [NAME] | 28810 | 11755 | EMPLOYEE | 12 | GS | 1 | 13 | INSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | A | [NAME] | 28810 | 11697 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | H | [NAME] | 28810 | 11751 | EMPLOYEE | 8 | GS | 1 | 13 | OUTSIDE | FIRST
CAMP | ATLANTA | SMITH | [NAME] | B | [NAME] | 28810 | 11775 | EMPLOYEE | 9 | GS | 1 | 13 | OUTSIDE | FIRST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4