J
Jim May
I receive raw data in excel as follows:
A B C D E
1 CC's '800090-0000 800090-0001 800090-0002
800091-0000
F G H I J
800091-0001 800091-0002 800092-0000 800092-0001 800092-0002
HEADER rOW>> WHICH contines to Col Y
2 01016010 123 0 4565
ETC for 400 Rows - There are many Blanks in the Columns B - Y
I need to (on a separate Sheet) get only those non-blanks above to look
like:
A
CC's Sub Amt
01016010 0000 123
01016010 0002 4565
Any advice appreciated,,
Jim
A B C D E
1 CC's '800090-0000 800090-0001 800090-0002
800091-0000
F G H I J
800091-0001 800091-0002 800092-0000 800092-0001 800092-0002
HEADER rOW>> WHICH contines to Col Y
2 01016010 123 0 4565
ETC for 400 Rows - There are many Blanks in the Columns B - Y
I need to (on a separate Sheet) get only those non-blanks above to look
like:
A
CC's Sub Amt
01016010 0000 123
01016010 0002 4565
Any advice appreciated,,
Jim