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 Enter...
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
