Hi,
I have some people picker columns in a sharepoint list that display, full name office location, phone number,etc. When I "export as a data feed" to PowerPivot, the columns only display the ID number. same goes for the CreatedBY and ModifiedBy
fields. Is there an easy way to get the actual name, phone number, etc to display in the PowerPivot table?
Thanks!
Paul