Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |