How to split the list into rows

[aswanim]

Hi,

I have a list for Classification IDs and Classification columns. How to get that list to be converted to rows . Delimiter is comma.

The output expecting is below for the highlighted Classification IDs row.

Topic title	Workflow Classification ID	Workflow Classification	Classification IDs	Classification
Løsning for innkassing av ventilasjon auditorium	72	Avvik	111	**bleep**Tømrar
Løsning for innkassing av ventilasjon auditorium	72	Avvik	197	ARK
Løsning for innkassing av ventilasjon auditorium	72	Avvik	201	RIVs
Løsning for innkassing av ventilasjon auditorium	72	Avvik	209	RIAku

Can you help me with this.

Thanks.

[wdx223_Daniel]

NewStep=Table.FromRecords(List.TransformMany(Table.ToRecords(PreviousStepName),each List.Zip(List.Transform({"Classification IDs","Classification"},(x)=>Text.Split(Text.From(Recrod.Field(_,x)??""),","))),(x,y)=>x&[#"Classification IDs"=y{0},Classification=y{1}]))