Pivot Table Condense Adresss

[ManUBlueJay]

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

 

[Kerryx]

Sometimes it is best to go back to the source data and make your life easy by just adding an extra column and concat the cells you need, call it AddressAll and pull that new column into the pivot table if you still want it.

 

[ManUBlueJay]

I discovered that it works by combining cells in the source data and adding Char(10), but you only see it in the pivot table if the col cells has wrap text enabled.

 

[Kerryx]

Book2.xlsx
	A	B	C	D	E	F	G	H
1	Add1	Add2	PCode	Name	AddAll
2	ln1	lnadd2	123	Jack	ln1,lnadd2,123
3	ln2	lnadd3	456	Jill	ln2,lnadd3,456
4	ln3	lnadd4	789	Mary	ln3,lnadd4,789		AddAll	Name
5							ln1,lnadd2,123	Jack
6							ln2,lnadd3,456	Jill
7							ln3,lnadd4,789	Mary
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=CONCAT(A2,",",B2,",",C2)

 

[Alex Blakenburg]

I discovered that it works by combining cells in the source data and adding Char(10), but you only see it in the pivot table if the col cells has wrap text enabled.

But that is true for the original table as well.
If you select the Pivot Column when you turn wrap on, you only have to do it once and it will apply to additional rows as the table expands.