Reformatting one column of text into a workable table

Hello.!

I work in a lab, and it is inventory-taking time. We recently started using a website to track all our chemicals, but the site we use does not let you choose a good format when you want to print a full inventory list, nor does it let you sort the list by anything other than chemical name. So I'm trying to paste it to excel and format it to something that is more useful so i can sort by location, storage color, etc and also print a hard-copy that will be easier to read and won't take 300 pieces of paper (see attached and you'll know what i mean).

I feel like this should be easy, but I'm pretty new with excel and keep having some troubles. I can (mostly) get the data into 2 workable columns and then transpose some of the useful stuff to rows, but can't figure out a way to have it transpose in an array or whatever so it auto-wraps to a new row every 14 cells.

Also the fact that the name of each chemical doesn't already have "name:" in front of it makes things annoying as well cause i used the colon as the delimeter in the text-to-column tool to split the data to two columns. Using the colon does screw up a lot of the notes though cause they often have colons in them too, so in those rows I get an extra 4 or 5 columns if we have multiple bottles of the same reagent.

Anyway I won't attach my botched attempts at getting this to work the proper way, but i can if needed. I have attached a sample before and after though. The before is completely raw how it pastes from the website.

thanks for any help :>

If you put the exact strings to "strip out" of the strings from the main sheet, including the space at the end, like "Location: ", in the titles of the "results" sheet, you can do this reorganization with a couple of formulas.

The "data" sheet appears to present the same # of rows per set of data, so the first cell in each "group" can be taken as is, but the rest need to strip off the title. So the two formulas needed are shown in this sample sheet.