yogi_Rearrange Data In 'Address' Column And 'Cars' Column Of Goals Sheet Per Specification

Google Spreadsheet   Post  #2525

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-25-2018

question by: Geo954
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/vA_zz0CoPVY;context-place=forum/docs

Query and limit output
Hi all it's difficult to explain so I appreciate any input. I'm trying to query data from one sheet and only show the output once. In sheet/tab "Goals" I have a client name listed a few times and want to query data from another sheet based on that name. However, I only want the data to appear once and then look for the next unique name skipping down to that row.   

I know I can query and have the output populate a list, but that list is aligned with the source data. I have an example sheet that shows the idea, what currently happens with a regular query based on the client name and finally, what I hope it can look like. 

Here is a link to the sheet. https://docs.google.com/spreadsheets/d/17OTd6oPV0Y84qPvo_K7AsCPMyHcapkq77SorIlOWDUo/edit?usp=sharing

Thanks for any ideas/input.