Ken

Select the Names column and F5SpecialBlanksOK

In the active cell enter an = sign then point or arrow to cell above then hit
CTRL + ENTER.

CopyPaste Special(in place)ValuesOKEsc.


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 17:46:00 -0700, Ken wrote:

I am creating a spreadsheet links to a Project Web Server timesheet cube,
and formats that data so that it can be pulled into Office Accounting and
other applications. I am using a pivot table, and almost have it formated
the way I want. I have one problem to solve.

Each employee has multiple projects. The employee is listed on one row in
column A and his projects are listed on multiple rows in column B. This
leaves empty fields where I need the employee name listed again:

Names Projects
1stname 1st Project
2nd Project
2ndname 1st Project
2ndProject

Does anyone know how I can get the names to show up for all rows?

Thanks,