You need to enter the person's name in all blank cells of column A.

Select column A and F5SpecialBlanksOK

In active blank cell type the = sign then point or arrow up to the cell
above.

Hit CTRL + Enter to fill blank cells.

Copypaste specialValuesOK.Esc


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 08:58:03 -0700, Meesh
wrote:

I need to be able to have wrapped text in multiple columns but also be able
to have formats across the way. To explain:

I need column A to be a person but that person would have info in rows
1,2,3. In other words, I want to be able to sort by the person but have
several rows for each person with formats to total across.

Thank you.