Taking entries from certain columns and putting them together

[Hitch75]

Hi everyone,

I have a huge spreadsheet where after every 12 columns there are two "special" ones, which contain certain entries. In the first of these two, the entries from the second one are numbered in a certain way. Please see the example.

I need a formula in a separate column (yellow) which will gather all these entries from all columns, and put them in order, as I did manually in this example.
Instead of 4 "groups" of columns, in my real file I have 200 of them, with 400 rows each, which makes it more complicated..

You can add some "help" columns if neccessary.

Thanx in advance!

[RudiS]

Hi,

Here is a macro that will collect the data as specified.
In the sample attached, when the macro prompts, select the entire range that defines the data block (excluding the columns where the codes must go), in the samples case that is range (A1:AZ29).

The macro will deposit the codes next the the right side of the list.

[Hitch75]

Thanks a lot, that will do!!