Transpose and Extract specific fields from a String of Data into a separate column

I have a data output from a software that folk want it transposed and select fields isolated for easy view. i attempted the record automate and quickly found out how useless it was despite easy the task is (except i have about 385 of them to do...)

Current Format is string left to right (blue) but they want it in top to bottom form (yellow)

Cool copy paste 385 times, whatever tedious to do but i can.while pulling out the (always in the same spots B1,C1,D1,E1,F1,G1) couple items and put them to the side. It would be best if i could also remove them from the main set so they're not duplicated (tho not necessary)

the A1-H12 for Set1 and Set2 is unfortunately across 385 spreadsheets that require me to view also in a particular order (that gets screwed up and is a whole different problem)

ps so sorry about the google sheets screen shot but i was never given a work laptop lolol and im not buying microsoft office for myself <3

[Example Data Here](https://imgur.com/a/TStcFPt)