Forum Discussion

Lukky123's avatar
Lukky123
New Member
3 years ago

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

 

Any ideas?

Thanks.

Need Help

3 Replies

  • Mkarwa-123's avatar
    Mkarwa-123
    Resolver II
    3 years ago

    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's avatar
      Lukky123
      New Member
      3 years ago

      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
      IndiGo06:30-09:10
      IndiGo12:45-14:20
  • Mkarwa-123's avatar
    Mkarwa-123
    Resolver II
    3 years ago

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

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