MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel formula

Posted by Michael Carter on September 16, 2001 7:07 PM

I have a row of cells some of which contain text and some values and some are empty.

How do I write a formula to arrangs particular cell entries (say nonblank cells only)from a range(c4:h4)into a column range (a10:a15)

Posted by . on September 17, 2001 3:56 AM

Sort then copy>pastespecial>transpose