How can I group multiple items under one column, using a comma delimiter?
如何使用逗号分隔符将多个项目分组到一列下?
For example.. I need my .txt file to contain: X,1,3,4 Y,9 7 8,2,5
例如..我需要我的.txt文件包含:X,1,3,4 Y,9 7 8,2,5
and the output should look like this below:
输出应如下所示:
X Y
------
1 9
7
8
------
3 2
------
4 5
2 个解决方案
#1
0
You need to be more specific. In Excel you can enter multiple lines in a single cell by using Alt-Enter in place of (newline) above.
你需要更具体。在Excel中,您可以使用Alt-Enter代替上面的(换行符)在单个单元格中输入多行。
#2
0
Turns out I had to use consecutive commas, to make the items fall in the correct column.
结果我不得不使用连续的逗号,使项目落在正确的列中。
#1
0
You need to be more specific. In Excel you can enter multiple lines in a single cell by using Alt-Enter in place of (newline) above.
你需要更具体。在Excel中,您可以使用Alt-Enter代替上面的(换行符)在单个单元格中输入多行。
#2
0
Turns out I had to use consecutive commas, to make the items fall in the correct column.
结果我不得不使用连续的逗号,使项目落在正确的列中。