Transpose or Pivot??

I have a table of data of customers. The column data includes the standard name, address, etc.. It also includes 1 column of the software platform they own. Because customers have multiple software platforms, there are multiple rows of the same customer data with the software column including the 2nd, 3rd, 4th, etc. software they own. How can I move all the separate rows of the software onto the first row of the customer creating multiple columns of the different software they own? It would be best to take the separate rows of software and add them onto the first row of the customer. Then I can remove all the additional rows of the customer. The final goal is to have one row per customer that includes the standard data like name, address, etc. and then multiple columns of software. So a variation of a transpose or is this a pivot need? Is this possible? A sample of data is attached.

Using the technique shown here https://sfmagazine.com/post-entry/ju...a-pivot-table/

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H
3	Church Name	Address	City	State	Zipcode	Phone	Primary Contact	Platforms
4	Fifth Avenue Presbyterian Church	7 W 55th St	New York	NY	10019-4902	(212) 247-0490	xxxxxx	ShelbyNext Giving, ShelbyNext Financials (Installed), Arena Select
5	First Baptist Church	1205 Spring St	Mountain Home	AR	72653	(870) 425-6961	xxxxxx	ShelbyNext Financials (Hosted)
6	First Pentecostal Church	5000 I 55 S	Jackson	MS	39272-5505	(601) 373-9000	xxxxxx	V5
7	First United Methodist Church	190 E Franklin Blvd	Gastonia	NC	28052-4105	(704) 864-4371	xxxxxx	Platform Bundle, ShelbyNext Financials (Hosted), ShelbyNext Membership, ShelbyNext Giving, ShelbyNext Website - Clover, V5
8	Lifegate Church	15555 W Dodge Rd	Omaha	NE	68154-2070	(402) 330-5724	xxxxxx	V5
9	Second Presbyterian Church	404 N Prairie St	Bloomington	IL	61701	(309) 828-6297	xxxxxx	ShelbyNext Financials (Hosted), ShelbyNext Giving, Platform Bundle, ShelbyNext Membership, ShelbyNext Website - Clover

Sheet: Sheet2

Look at the link I provided

Hi gman and welcome to the forum,

I have no idea what Dax is either, so I've done your problem with a helper column. First I did a Unique() on column 2 below your table. Then a helper to count how many of each in the last column.
See the attached with the final answer below your table. Neither Transpose or Pivot but Unique and.xlsx Click on the link to the left.
Hope this does what you need, and you can follow the logic. BTW - Unique() is only in the newer versions of Excel.

here is my file

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.