Organize Dataset

Hi all.

Hope you guys are safe and well.

I have a dataset where the code and name of the factory appears (highlighted in yellow in the attachment) as a row above the respective factory data.

Is there a method to organize the dataset where each factory's code is placed in column A (from cell A24 to A31) and its corresponding name is placed in column B (from cell B24 to B31), repeating this process for all factories in the dataset?

In the attachment, I've manually transferred the data for the initial factory - Graceland.