Is this what you want to achieve?

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

If yes. You cannot use the pivot to get this directly. But instead, create
the pivot table first, then copy it to somewhere and paste data. Then you
need a formula likse liks by inserting a col in the middle to "fill-down" get
the missing part.

Start with the 2nd cell (b2), the first cell you need to copy from A1
=IF(A2="",B1,A2)

Then copy and paste down then you will get the result.

then copy and paste value for this middle col. Then finally delte the first
col. let's make it Col "B".



"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,

--
Ken