How to repeat index column, but have unique record from other columns

[benkenten]

Hi All

I have the following data

Respondee	Response Time	Month	Project 1	Days 1	Project 2	Days 2	Project 3	Days 3
mickey mouse	08/02/2023 15:42	Jan-23	Researching Things	6.5	Buying Things	6.5	Making Things	8

But I need it in the following format:

Respondee	Response Time	Month	Project	Days
mickey mouse	08/02/2023 15:42	Jan-23	Researching Things	6.5
mickey mouse	08/02/2023 15:42	Jan-23	Buying Things	6.5
mickey mouse	08/02/2023 15:42	Jan-23	Making Things	8

Is this possible in Power Query? To Repeat my first 3 "index" columns, but to "pivot" the other columns next to them?

Many thanks 🙂

[HotChilli · Accepted solution]

Yes, it's possible.

Select 1st 3 columns and UNpivot Other columns.

Split the attribute column (on non-digit to digit).

Pivot the Attribute1 column using Value in Values and 'Do not aggregate' in Advanced section

[benkenten]

That's super helpful, thank you HotChilli. I'm just learning how useful PQ is.