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.

You cannot move data using a formula, but you can reference it. If you want those header rows eliminating, as you have demonstrated, then you'll need VBA for this. Shall I move the thread for you?

Thread has been moved.

Please Login or Register  to view this content.

Input: TEST_IN, output: TEST_OUT

Please Login or Register  to view this content.

My error in copying code: my apologies although correct in posted file!

You're welcome: have a good day