Hi Paul,

I messed around with this again today, but still can't seem to find a proper solution.

Here is an example Excel file with the preferred output.

Basically, I'm just interested in the yellow highlighted rows with the data in-between the yellow rows which is 7 columns worth of data.

I don't need anything in red, green, or even the gray headers.

As for the headings in the data, not interested in any headers. In the yellow rows, I'm even only concerned with the first two data elements nor am I concerned with alignment within the cells.

All that format type stuff is secondary. The main task is just to get the data positioned in columns and rows.

Attached Files

Data.xlsx (8.6 KB, 12 views)