Collating Information but exclude errors

I to collate information, but some of the date is #N/A and this will change. I have sorted the Information so #N/A's appear at the bottom -

Cooperation
Curriculum Linked Activities
Familiarisation
Fun
Personal Challenge
Personal Development
Personal State Management
PSE
Self Belief
Skill Acquisition
Support
Training Course
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A


I can collate by &", "& - but i dont need the information of the #N/A - the Ammount of #N/A will vary - so figured using a countif - but its baffling me.

Cheers in advance!

So the end result I want is -

Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course

BUT...

It needs to be depandant on the #N/A's as it could change too -

Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge

I can get it so the end result is - Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course, , , , , , ,

But need to exclude these last commas.

Hope that makes sense

So sheet one is a matrix - that 1 Signifies it matches that point - Sheet 2 refers that to a Number to reflect the Lookup.

Sheet 4 is where having the issue - (I have proberly gone the long way round it all)

I have Sorted - I want to combine as mentioned above to give result such as -

Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development, Personal State Management, PSE, Self Belief, Skill Acquisition, Support, Training Course

Hope that abit more useful

I'll try an explain better -

So the first sheet is the data entry - So can Put a '1' to say it matches that criteria e.g. Fun -

The purpose of the worksheet is to collate this information.

So on the last sheet it will have -

Abseiling - Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge, Personal Development
Climbing - Cooperation, Curriculum Linked Activities
High Ropes - Cooperation, Curriculum Linked Activities, Familiarization, Fun, Personal Challenge

I hope that makes abit more sense

=IF(ISNA(VLOOKUP(A2,Sheet3!A1:B22,2)),"",VLOOKUP(A2,Sheet3!A1:B22,2)) in Sheet4 ??

Thanks for you help!


Sheet one is the data entry

Sheet 2 - converts that data entry to a numeric so that it can be used on a Vlookup to find the relevant info - e.g. Fun

Sheet 3 is the source for the lookup

Sheet 4 is vlookup is a "1" is on the data entry sheet.

Sheet 5 is the results - (I have added some notes)

I have added some notes on the workbook in read - should makes things clearer

Sweet Thank you just what I wanted! Just need to understand it now, so I can replicate it! Thanks for your help!