Now I want to move every value to a separate, corresponding column (second value should move to second column in a row, third to the third and so on).Paste it to a single cell (first in a row).I copy a single row from CSV - values are separated with semicolons everything between two commas should be treated as a single value (even if there are any commas inside).What I need to do is to copy only a single row from CSV (values separated with semicolons) and then spread/populate the inserted data from a single cell to the rest of the columns (all values separated with semicolons should move to their respective columns). To make sure the changes were live and checked Options if the checkboxes were unmarked once again, but everything was fine there and saved as I wanted. There's no "new"/old option to use an old import text wizard while pasting a line from CSV added to the context menu (it appeared earlier right after pasting a line in a cell). Tried to add old legacy text wizzards via Options as per īut Legacy Wizards under Get Data remain grayed out.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |