Split column

[Gillard_2]

Hi, 

I am hoping to split a single column into multiple, having a column for each licence type. Thanks in advance

Single Column:

Result Columns from above single column:

Office 356 Enterprise E3	Power-BI Standard	Enterprise Mobility + Security E3	Office 365 Enterprise E3	Visio Online Plan 2	Dynamics 365 Plan 1 Enterprise Edition
Yes	Yes	Yes	Yes
Yes	Yes	Yes
Yes				Yes	Yes
		Yes	Yes	Yes

[Gillard_2]

Not sure i am clear on all the required steps from the above replies. A more detailed breadown of each step required would be greatly appreciated.

Thanks in advance

[wdx223_Daniel]

NewStep=Table.Combine(Table.ToList(PreviousStepName,each let a=Text.Split(_{1},",") in #table({"Email Address"}&a,{{_{0}}&List.Repeat({"Yes"},List.Count(a))}))

[6677028]

you can upload data by excel file

[serpiva64]

Hi,

you obtain this

- split column by delimiter

- traspose table

- keep top rows 1 (it is your columnNames)

- combine the table with your names with the full table (the step before)

= Table.Combine({ ColumnNames , #"Transposed Table"})

- promote headers

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[Gillard_2]

Apoligies, i dont think i was as clear as i needed to be with the outcome required. The table I posted also have annother column of email addresses (these are all unqiue).

So the outcome required is as follows:

Email Adress	Office 356 Enterprise E3	Power-BI Standard	Enterprise Mobility + Security E3	Office 365 Enterprise E3	Visio Online Plan 2	Dynamics 365 Plan 1 Enterprise Edition
a@help.com	Yes	Yes	Yes	Yes
b@help.com	Yes	Yes	Yes
c@help.com	Yes				Yes	Yes
d@help.com			Yes	Yes	Yes