Forum Discussion
Transpose multiple columns into single column retaining the main column
Greetings,
I'm bagging my head against the wall trying to transpose/pivot my data. Here's my dataset below:
| Sales ID | Ticket 1 | Ticket 2 | Ticket 3 |
| 1 | Funny | null | null |
| 2 | Happy | Serious | null |
| 3 | Fun | Ugly | Vanity |
What I'm trying to do in my table is this:
| Sales ID | Ticket |
| 1 | Funny |
| 2 | Happy |
| 2 | Serious |
| 3 | Fun |
| 3 | Ugly |
| 3 | Vanity |
Does anyone know how I do this in Power BI, I did it before but was a long time ago?
Power Query. select 1st column. Right-click. Unpivot other columns
