Need:Show Name, Address 1, Address 2, City, State, ZIP and ID in Row Field on a single row by name using Pivot Table. Data is dynamic and output must update after data is changed.
I have a data array composed of multiple columns for Project, Company, Percentage Owned, Partner Name, Address 1...