A bit of a manual process but you could do the following:
- Use
Text to Columns
to separate the properties. - Copy the properties and use
Paste Special
andTranspose
to flip the column data to rows. - Fill the identification ID down to have it align with the properties.
If I had to fix up the sheet once that would probably be how I would do it. If I had to do it multiple times I would write a VB script to automate the process. You can see my answer to this other question about transposing rows/columns for an example of a script to do this.