Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Lukky123
New Member

Matching specific values to their columns

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
IndiGo06:30-09:10
IndiGo12:45-14:20

From this

Initial.PNG

 

Any ideas?

Thanks.

3 REPLIES 3
Mkarwa-123
Resolver II
Resolver II

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

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

Mkarwa-123
Resolver II
Resolver II

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. 

I just tried that. It produced some duplicates.
This
Initial1.PNG

Instead of this

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.