如何创建新行数据基于分割生产er values in Column data

Vanlal

I have data like as below

Name	Subject	Grade
约翰	Eng,Math	A,B
Clarice	Eng,Science	O,B
Kennedy	Math	O
Kevin	Eng	A

How do i generate new rows based on the column which has , on them

Name	Subject	Grade
约翰	Eng	A
约翰	Math	B
Clarice	Eng	O
Clarice	Science	B
Kennedy	Math	O
Kevin	Eng	A

MartinLiebig

Hi,

you want to use Split+DePivot as operators.

Best,

Martin

Vanlal

< div > < ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程s version="9.6.000">