calculate average if all values are positive and move data based if located

Hey
I have two problems. I attached a excel file with discription and some numbers examples.

1. problem one move some data from one tab to another based on if the name of the column is present in another.
2. problem two calculate average between 3 datasets if the numbers in each of the datasets are posivite.

Thanks for any feedback!

In X9, then drag across

Please Login or Register  to view this content.

For problem 2
ARRAY formula in G14.
ARRAY formula is to be confirmed with Ctrl+Shift+enter keys together not with only Enter key.

Please Login or Register  to view this content.

Thank you very much kvsrinivasamurthy.