Matching specific values to their columns

[Lukky123]

Hello. I am relatively new to Power BI.
I am working on cleaning the data below and would like the Airline and Onwards Return Flight Time format to be something like this:

Airline	Onwards Return Flight Time
IndiGo	14:00-16:05
Spicejet	15:45-17:45
IndiGo	10:50-13:00
IndiGo	06:30-09:10
IndiGo	12:45-14:20

From this

Any ideas?

Thanks.

[Mkarwa-123]

You can use remove duplicates, if you dont need them.

Did I answer your question? Mark my post as a solution!

[Mkarwa-123]

Hi @Lukky123 
You can first split on I on Arline and onward return flight time. 
Once you get all the columns you can unpivot data to get the desired format. 

[Lukky123]

I just tried that. It produced some duplicates.
This

Instead of this

Airline	Onwards Return Flight Time
IndiGo	14:00-16:05
Spicejet	15:45-17:45
IndiGo	10:50-13:00
IndiGo	06:30-09:10
IndiGo	12:45-14:20