Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

Here's one solution but I'm pretty sure it aint gonna work.
You could match the "Brand" in column A with column D so you pull across the right data.
But I;m pretty sure your data doesn't look like

Fred's Store
Fred's location
...
...
...
Bert's Store
Bert's Location
...
...

So what's your actual data look like? Make it up if it's sensitive.

Does EVERY entry have 9 lines then a blank?

if it is regular (each store has the same number of rows for description it would be pretty easy with formulas Using OFFSET (or INDIRECT if you prefer) and ROW
for instance simple one in D4:

Formula:

Please Login or Register  to view this content.

and copy down, E5:

Formula:

Please Login or Register  to view this content.

etc.