ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I have a data table that has a Col for each field. Name, Company, Address1, Address2,Post Code, Town, Job Title, Email, Phone, Notes
Is there a way to make a nicely laid out pivot where I could show the address Fields in 1 Col, Contact Fields in Col2 and Notes in Col3
I have tried making combined Fields in the Table with Char 10 but that does not get carried over to a Pivot Table
Any Help on the table or the pivot would be appreciated. There is no Math involved, Just display
Is there a way to make a nicely laid out pivot where I could show the address Fields in 1 Col, Contact Fields in Col2 and Notes in Col3
I have tried making combined Fields in the Table with Char 10 but that does not get carried over to a Pivot Table
Any Help on the table or the pivot would be appreciated. There is no Math involved, Just display