No go; The output on sheet 2 is just the identifier; none of the following columns. It does consolidate the identifiers though so that's a solid step ahead of where I was yesterday.

Here is a better sample of my data sets (Should just copy/paste):

109-8138 21929 0 0 101 988 3312 1944 2868 2872 3052 3032 2048 1712
109-8199 17815 0 0 75 640 2068 1644 2656 2244 2572 2516 1872 1528
109-8573 32218 0 0 90 1008 3260 3148 4920 4212 4988 4696 2932 2964

Thanks rylo,