Forum Discussion
Split column
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 |
5 Replies
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!
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 [email protected] Yes Yes Yes Yes [email protected] Yes Yes Yes [email protected] Yes Yes Yes [email protected] Yes Yes Yes
you can upload data by excel file
NewStep=Table.Combine(Table.ToList(PreviousStepName,each let a=Text.Split(_{1},",") in #table({"Email Address"}&a,{{_{0}}&List.Repeat({"Yes"},List.Count(a))}))
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
