Identify values in a specific column and list them on another column!! PLEASE HELP!

Book1.xlsx



So this is what my cells look like but only in the hundreds of thousands of rows! So i need to scan the columns and see where there are numbers (release numbers). When I find the release numbers, i want them to be reported back (copy-pasted) into the 'Release' column. Now this is where this gets tricky! Ok once I get the release data into the release column, I need that heading of the column to be reported back to the 'Product'.

For example:
If i start scanning the first row. The MBG has a reportable 'Release' version. So this gets reported back to the 'Release' column and the heading of this column - 'MBG' in this case gets copied to the 'Product column'!!!

Any ideas??

Will there be any instance where you'd have version numbers in more than one cell in the same row?

Here is the long way, assuming you don't have more columns that those you showed on your example, and that no more than 1 version number will appear per row:
Enter on A2:

Please Login or Register  to view this content.

Enter on B2 (Sorry for the long formula, I'm not that good with arrays):

Please Login or Register  to view this content.

Drag down as needed.