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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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