Transpose multiple columns into single column retaining the main column

[Anonymous]

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?

[Anonymous]

@HotChilli Awesome, thank you, could not figure it out 🙂

[HotChilli · Accepted solution]

Power Query. select 1st column. Right-click.  Unpivot other columns