I am wondering if there is an elegant way to apply either a combination of query, Arrayformula, sort, functions in Google Sheets to do the following

Google Sheets Problem. I have a master list that has columns which are employers, job post, # of spots, parameter x, parameter y,…etc. “Master Sheet” #a tab Employers Job Spots John Cleaner 1 Mike Cleaner 2 John Cleaner 3 John Server 5 Alice Cook 1 Dave Cook 1 Mary Cleaner 3 Alice Server 5 Alice…

Details

How to display one term before other in comma separated list?

I’m displaying post’s custom taxonomy terms as comma separated with this one: $taxonomies = get_object_taxonomies( $post, ‘objects’ ); foreach ( $taxonomies as $taxonomy ) { $tax_name = $taxonomy->labels->singular_name; the_terms( $post->ID, $taxonomy->name, ‘<div class=”e-post__details- item-taxonomy”>’, “, “, ‘</div>’ ); } Terms are ordered alphabetically, by name, but I have one term inside my custom taxonomy that…

Details