I have a file that looks like this:
1111 51 09/26/07 100.00
09/21/07 1001.92
09/06/07 645.00
09/05/07 2774.75
TOTALS 4 4521.67
2222 50 09/28/07 750.00
09/14/07 500.00
09/13/07 3000.00
TOTALS 4 4392.00
3333 50 09/26/07 1220.00
09/05/07 1023.57
09/04/07 285.00
09/04/07 617.90
TOTALS 4 3146.47
Here is my desired output:
1111 51 09/26/07 100.00
1111 51 09/21/07 1001.92
1111 51 09/06/07 645.00
1111 51 09/05/07 2774.75
TOTALS 4 4521.67
2222 50 09/28/07 750.00
2222 50 09/14/07 500.00
2222 50 09/13/07 3000.00
TOTALS 4 4392.00
3333 50 09/26/07 1220.00
3333 50 09/05/07 1023.57
3333 50 09/04/07 285.00
3333 50 09/04/07 617.90
TOTALS 4 3146.47
How do I get there?
Thanks!
1111 51 09/26/07 100.00
09/21/07 1001.92
09/06/07 645.00
09/05/07 2774.75
TOTALS 4 4521.67
2222 50 09/28/07 750.00
09/14/07 500.00
09/13/07 3000.00
TOTALS 4 4392.00
3333 50 09/26/07 1220.00
09/05/07 1023.57
09/04/07 285.00
09/04/07 617.90
TOTALS 4 3146.47
Here is my desired output:
1111 51 09/26/07 100.00
1111 51 09/21/07 1001.92
1111 51 09/06/07 645.00
1111 51 09/05/07 2774.75
TOTALS 4 4521.67
2222 50 09/28/07 750.00
2222 50 09/14/07 500.00
2222 50 09/13/07 3000.00
TOTALS 4 4392.00
3333 50 09/26/07 1220.00
3333 50 09/05/07 1023.57
3333 50 09/04/07 285.00
3333 50 09/04/07 617.90
TOTALS 4 3146.47
How do I get there?
Thanks!