rearrange by attribute,value row spacing

I have received spreadsheets with many rows that are set up as lists of attribute and value but because not all rows have the same attributes the columns are not aligned similar to below. Is there a way in excel to align the columns where they are for the same attributes?

this is what my spreadsheet looks like

animal, dog, name, fido, color, brown
animal, cat, name, sally, color, yellow
animal, bird, wings, clipped, name, tweety, color, yellow

as you can see the name attribute for them would fall into separate columns based on the number of attributes for each type of animal

and I want this

dog, fido, brown, ""
cat, sally, yellow, ""
bird, tweety, yellow, clipped

Any ideas on how to align this information in excel? Thanks.

Hi nf1030,

Here is my solution. I created a sorting solution using formulas on sheet 2. The formulas can be dragged down as far as you need, as well as across as long as you drag the across formulas IN PAIRS.
Specifically meaning if you want more columns of information you will need to grab, say K4 and L4, then drag across together, then drag down the length of your list on sheet 1.
In order to make a new category appear simply put the name in the appropriate column in row 1, like the examples I put in. Spelling must be exact however you can arrange them in any fashion.
I made the following assumption: Your sheet1 began at row 4, so my formulas do as well. If your real data starts elsewhere you will need to adjust the formulas.
When complete, you can copy/paste values on sheet2 if you wish.
Squeaky.