Formula to transpose data based on if other cells have a value

[Tim_Excel_]

Hi forum,

I am trying to create a single column of machine numbers and repair intervals out of multiple columns. 3 columns (J, L and N) show whether a specific machine needs a 3-monthly, 6-monthly or yearly repair, or a combination of the three. In column A I want a list of all machine numbers which have been marked for repairs. If a machine is marked for 3 and/or 6 monthly repair, column A needs to contain the numbers from column G. However, if a machine is (also) marked for a yearly repair, then the numbers from column I (additionally) need to be in column A.

To clear it up:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]G[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]L[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Results[/TD]
[TD]03M/06M Codes[/TD]
[TD]12M codes[/TD]
[TD]03M[/TD]
[TD]06M[/TD]
[TD]12M[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0700.01<strike></strike>[/TD]
[TD]0700.01[/TD]
[TD]0700.00[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0700.01<strike></strike>[/TD]
[TD]0800.01[/TD]
[TD]0801.01[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0800.01<strike></strike>[/TD]
[TD]0855.01[/TD]
[TD]0855.01.01[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0801.01<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0855.01<strike></strike>.01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I surely hope you can help me out, because it's day 3 of trying to solve this and it seems more and more impossible