Hi all,

I'm semi familiar with macros but seem to be stumped by this issue and couldn't find anything online to help. I have a bunch of long (over 1000 rows each) excel columns that I need to reorganize into rows with common headings.

Currently, the data is organized as follows, in one column:

Plant name
Jay Enterprise
Plant Manager
John Jay
Date of closing
Aug-16
Plant size
250,000 Sq Ft
Employees
7500
Plant name
Jay Enterprise
Plant Manager
John Jay
Date of closing
Aug-16
Plant size
250,000 Sq Ft
Employees
7500
Plant name
Jay Enterprise
Plant Manager
John Jay
Date of closing
Aug-16
Plant size
250,000 Sq Ft
Employees
7500

Is there a macro I can use to split up the single column into multiple columns all beginning with the heading 'Plant Name'? As a side note, not all of the data is the same number of cells. Some of the columns would have to be 21 cells, others 18, etc etc., so I cannot use the offset function.

Any help would be greatly appreciated!