I am not aware of any way to do that automatically (no pivot table diplay
option). Also, it it remains a pivot table, you can't do it manually
either.

--
Regards,
Tom Ogilvy

"Bill G" wrote in message
news:NlWAd.727237$mD.201564@attbi_s02...
I have a pivot table and would like to auto-fill cells based on the
first line of each entity. Example:

Current representation on Pivot Table

Hospital 1 Project Manager 1 (First Line)
Blank Blank
Blank Blank
Blank Blank
Hospital 2 Project Manager 1
Blank Blank
Blank Blank
Etc.

Requirement

Hospital 1 Project Manager 1
Hospital 1 Project Manager 1
Hospital 1 Project Manager 1
Hospital 1 Project Manager 1
Hospital 2 Project Manager 1
Hospital 2 Project Manager 1
Hospital 2 Project Manager 1

Is there any way to do this automatically?

Thanks

Bill