I have a problem. Starting from a txt file I have to create an excel file ordered on three columns.
The problem is that I have to search for words in a string and, depending on the word, copy the following lines to a different column.
Attached:
1. the txt file
2. the excel blank file
3. the excel file obtained by splitting the lines of the Txt and CSV file
3. the excel file that I should get
Any ideas on how to do it?
The problem is that I have to search for words in a string and, depending on the word, copy the following lines to a different column.
Attached:
1. the txt file
2. the excel blank file
3. the excel file obtained by splitting the lines of the Txt and CSV file
3. the excel file that I should get
Any ideas on how to do it?