Need help with pivot/unpivot of multiple columns into rows.

[Azurine13]

I'm not sure that this can be done easily, but I have a table that holds multiple events in a single row. I need to break those events out into their own unique row to use in a visual. My dataset is fairly large and I can't change the structure unfortunately.

Here is an example of what I have vs. what I need to achieve: 

Any help is greatly appreciated, thank you!

[Azurine13]

I can't believe it was this easy, thank you so much!! I was able to follow your instructions perfectly.

[FromZero2BIHero]

 Here is my solution to a similar problem:

Pivot Multiple Columns Groups into Rows

[gmsamborn · Accepted solution]

Hi @Azurine13 

I decided to do this in Power Query.  Fortunately, there is no coding.  The steps are as follows:

1. I merged the Break 1 columns into a single column with delimiter as "|".    (Select all 3 columns, right-click and select Merge Columns.)
2. I merged the Break 2 columns into a single column with delimiter as "|".
3. After selecting [Name], [Department], and [Date], Unpivot Other Columns.
4. I removed the [Attribute] column.
5. I split the [Value] column By Delimiter with delimiter set to "|".
6. I filtered to get rid of blank rows.
7. I renamed the columns.

Unpivot to multiple rows.pbix