S
S
Shing2016-01-10 20:59:54
excel
Shing, 2016-01-10 20:59:54

How to sort columns in relation to each other, and by keyword?

How to sort columns in relation to each other, and by word within a sentence?
For example, there are columns
Vanya goes to school | She likes her school
Petya studies at her favorite academy | He loves to go to school
Valya visits his school | Academy near the house
Galya entered the academy | Not far from home academy
How can I make the values ​​containing the keyword "academy" or "school" opposite each other, on the same line?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question