Formula to reproduce data from columns into new columns without #N/A

Hi,

I am looking for a formula (not a macro) that will reproduce data from two columns that are 29 rows long into 2 new columns that only include values that are not #N/A.

So for example if i have

1.29 22.30%
2.73 21.50%
2.26 30.20%
#N/A #N/A
1.13 23.50%
0.57 14.10%
0.84 9.90%
0.95 11.00%
1.74 17.90%
1.48 23.70%
2.60 26.60%
1.89 31.20%
#N/A #N/A
0.93 22.90%
#N/A 40.50%
0.94 16.80%
#N/A #N/A
2.83 24.10%
1.86 32.00%
0.82 14.30%
0.55 9.00%
1.22 27.30%
2.69 27.20%
#N/A #N/A
#N/A #N/A
1.08 20.70%
2.53 34.50%
0.77 7.90%
0.43 17.50%

I want these into two new columns where the list is only 23 rows long since the #N/As are not included. Also, if one of the colums has an #N/A value then i do not want that row value from the other column to appear either.

Is this possible using a formula?? A macro would make it very messy for my purpose. Sorting is also not something that would work since these values update constantly based on values from another sheet.

Thanks,

Harald