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 |