Concatenatex - alphabetical order|Power Pivot|Excel Forum|My Online Training Hub

Hi all,

I have a table with a list of site locations, a project date, project strategy and other information.  I also have a Power Pivot table which then sorts that information by strategy and month and displays the list of names using a measure.

Is there a way to have the measure output the list in alphabetical order?  Currently, the measure outputs it in the order as set in the table (date, site name), however, it would be useful for crosschecking purposes (as the projects are listed in a PowerPoint for Executive review) to be able to have the sites ordered by site name in the month.

Currently, the measure is as below;
=CONCATENATEX(values(Table3[Site Name]), Table3[Site Name],", ")

Thanks, Rob