I have 5 columns:
How can I get this result?
Thank you..
After you open the CSV file, click the Extract Columns button on the CSV/Sort toolbar. In the Extract Columns dialog box:
Select the columns 2 - 4, and set the Combine with previous column and Use first non-empty value options.
Click OK.