将用逗号分隔的表扩展为多行 [英] Expand a comma separated table in multiple rows

问题描述

我有一些带有键的表，并以逗号分隔的方式将多个值关联到该表.希望将其更改为每个值一行，如下所述多次重复该键.

I have some table with a key and multiple values associated to it in a comma separated way. Would like to change it to one row per value, repeating the key multiple times as follow.

您会知道如何在没有任何Excel宏的情况下吗?

推荐答案

假设您的数字是文本格式，并且abc在A2中，请选择ColumnB，DATA>数据工具-文本到列，定界，逗号，列数据格式文本(针对所有列)然后标记列，并通过数据透视表从数据中创建具有多个合并范围的表格，如此处.删除ColumnB并过滤值"列以删除空白行.

Assuming your numbers are text format and abc is in A2, select ColumnB, DATA > Data Tools - Text to Columns, Delimited, Comma, Column data format Text (for all columns) then label the columns and create a Table via a PivotTable from your data with Multiple consolidation ranges as described here. Delete ColumnB and Filter the Value column to remove blank rows.

这篇关于将用逗号分隔的表扩展为多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！