Formula Layout
 

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