Function 12)

12) Add Function JoinFromBelow

Using the function

=JoinFromBelow ( MainCriteria , JoinThisData , Separatingcharacter)

You can join data from extra rows into the main row. By joining the data into the one main row you will be able to sort and do other things with the data that you would not be able to do had this “extra” data resided on these subsequent rows.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc