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