Combine rows in Power BI (same column members but different values)

[Doritito]

 

I would like to combine some rows in my PowerBI Query that have all the same members (e.g. 2022 / 2022/Q1 / 2022/1 / xx) but a different value for each line. The different value for each line is a result of excluding some columns that originally have been in the Query (there were columns like "material number" and "customer" that I did not need). All the Data is coming from an Oracle Database. How can I avoid having these many lines?

Edit: The Delivery Plant Column has the same value for each row (e.g. 8720), I just had to blur it.

Real Example of the Problem:

 
Other examples:

1. How it looks when I pull the data from the datasource:

2. How it looks after removing the columns:

3. How I want the data to look:

[Doritito · Accepted solution]

Group by worked for me as solution.

[VijayP]

@Doritito 

Please watch this small video to understand how to get your answer 

https://drive.google.com/file/d/1749BiT-iGVsgx65506hEu2oW9j4Y9ga-/view?usp=share_link

[Doritito]

Dear @VijayP 

thanks so much for taking the effort and creating this video. This already helps me to see the data in a visualization the way that I want. But how can I see the data this way in the "Transform Data" view and avoid duplicated rows that just have different values directly when loading the data?

Thanks, Timo

[VijayP]

@Doritito 

Sample data with problem statement and what outcome you want to see as snapshot will help us to answer better

[Doritito]

Thanks for your answer @VijayP ! I modified my question, please have a look.