table / query - reorder the display to avoid showing blank rows at top for columns
I have a table or query result set [TeamSupporter] which shows like TeamSupporter.JPG below.
However, I would like to show like the following view, so that for each district, the supporters' names will reach to the topmost of the column within the same FormDistrict like TeamSupporterNewView.JPG below.
What I should do as I am using access2010? I haven't work with SQL or VBA for a long time so I am not sure whether it is possible to show. Thanks in advance for your help.