- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
重复单元格
This post originally written in French has been computer translated for you. When you reply, it will also be translated back to French .
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复:dupliquer les cellules
这应该可行,但我不能 100% 确定在所有情况下
起始表
1. 选择包含要分隔的值的列
2. 选择列后转到 Cols/Utilities/Text to Columns...
3. 并使用 - 作为分隔符。 按确定
4.转到表/堆栈
5. 将新列添加到 Stack Columns
6. 尝试最适合您情况的设置,然后按 OK
7. 在新表中,从新创建的数据列中选择一个空值(如果有),然后选择“选择匹配单元格”
8.右键单击行选择器并删除行
9. 从表中删除和重命名列
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复:dupliquer les cellules
这应该可行,但我不能 100% 确定在所有情况下
起始表
1. 选择包含要分隔的值的列
2. 选择列后转到 Cols/Utilities/Text to Columns...
3. 并使用 - 作为分隔符。 按确定
4.转到表/堆栈
5. 将新列添加到 Stack Columns
6. 尝试最适合您情况的设置,然后按 OK
7. 在新表中,从新创建的数据列中选择一个空值(如果有),然后选择“选择匹配单元格”
8.右键单击行选择器并删除行
9. 从表中删除和重命名列
This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).