how to split rows by each text

Question

Hi,&nbsp;&nbsp;&nbsp;Holiday Table:Date&nbsp;Company Code03/08/2022&nbsp;0035,0023,882114/10/2022&nbsp;MARFL&nbsp;&nbsp;I want to split this multiple valued rows to single.&nbsp;Should be like;Date&nbsp;Company Code03/08/2022&nbsp;003503/08/2022&nbsp;002303/08/2022&nbsp;882114/10/2022&nbsp;MARFL&nbsp;&nbsp;Thank you.

christiandgreat · Accepted Answer

Hi&nbsp;frknklcsln&nbsp;&nbsp;You can easily achieve this in Power Query.&nbsp;ThanksChris

Forum Discussion

how to split rows by each text

1 Reply

Related content

Split and transform columns into rows

Split values in one row into multiple

split rows

Splitting Column values

Split array into rows

Date		Company Code
03/08/2022		0035
03/08/2022		0023
03/08/2022		8821
14/10/2022		MARFL