Data model - Unpivot

[Prabha45]

Hi All,

I have a table(data model) like the below. For every quarter there will be 2 new columns( Status and comments).
I tried unpivot the Q3, Q4 status in one table and in the other by Q3, Q4 comments. And merge these two tables but I did get the required table 2. What transformations I need to perform to get table 2.

Category	Sub Category	Q3- 2023 status	Q3- 2023 comments	Q4- 2023 status	Q4- 2024 comments	Owner
Road	Bike	In progress	Working	In progress	N/A	David
Road	Car	In progress	Under validation	Completed	N/A	Smith
Electronics	Phone	In progress	Working	Completed	N/A	Henry
Electronics	Laptop	In progress	Manufacturing	In progress	Manufacturing	Micheal
Electronics	Headphones	In progress	N/A	Delayed	Working	Neil
Clothes	Shirt	In progress	Transportation	Delayed	Received on Monday	Peter
Clothes	Trousers	In progress	Transportation	Completed	Done	Chris

 Table 2 - 

Category	Sub category	Quarter	Status	Comments	Owner
Road	Bike	Q3-2023	In progress	Working	David
Road	Bike	Q4-2023	In progress	N/A	David
Road	Car	Q3-2023	In progress	Under validation	Smith
Road	Car	Q4-2023	Completed	N/A	Smith
Electronics	Phone	Q3-2023	In progress	N/A	Henry
Electronics	Phone	Q4-2023	Completed	Working	Henry
Electronics	Laptop	Q3-2023	In progress	Manufacturing	Micheal
Electronics	Laptop	Q4-2023	In progress	Manufacturing	Micheal
Electronics	Headphones	Q3-2023	In Progress	N/A	Neil
Electronics	Headphones	Q4-2023	Delayed	Working	Neil

Thanks in advance

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[Prabha45]

Thank you very much. Can you please explain the grouped rows step

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but after unpivotting each table, please try APPEND function in Power Query Editor.

Append queries - Power Query | Microsoft Learn