unpivotting multiple columns with different names

Question

Hi all any help is appreciated.&nbsp;following is the data i have&nbsp;StateSiteProject 1New DateStatusProject 2New DateStatusProject 3New DateStatusProject 4New DateStatusState 1Site 110/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 1Site 210/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 1Site 310/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 2Site 410/01/2021&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not StartedState 2Site 510/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 2Site 610/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 710/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 810/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 910/01/2021&nbsp;Completed&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not StartedState 3Site 1010/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 1110/01/2021&nbsp;Completed&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not StartedState 3Site 1210/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 1310/01/2021&nbsp;Completed&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not StartedState 3Site 1410/01/2021&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Completed&nbsp;&nbsp;Not StartedState 3Site 1510/01/2021&nbsp;Completed&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not StartedState 3Site 1610/01/2021&nbsp;Completed&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;Not Started&nbsp;&nbsp;what i want is&nbsp;&nbsp;StateSiteProjectsValueState 1Site 1Project 110/01/2021State 1Site 1New Date&nbsp;State 1Site 1StatusCompletedState 2Site 1Project 2&nbsp;State 2Site 1New Date&nbsp;State 2Site 1StatusCompletedState 3Site 1Project 3&nbsp;State 3Site 1New Date&nbsp;State 3Site 1StatusCompletedState 3Site 1Project 4&nbsp;State 3Site 1New Date&nbsp;State 3Site 1StatusNot Startedetc&nbsp;project name will keep on changing&nbsp;&nbsp;&nbsp;

jaipal · Answer

kevinfoch1&nbsp;go into your Power Query,select columns Project1----&gt; all the way to end, select Unpivot Columns as follows&nbsp;Rename the Columns&nbsp;

v-janeyg-msft · Answer

Hi,&nbsp;kevinfoch1&nbsp;
&nbsp;

Why here are status2 and status3? I'm counfused, can you explain it?
&nbsp;
Janey

Forum Discussion

unpivotting multiple columns with different names

2 Replies

Related content

Pivot / Unpivot?

Advanced unpivoting multiple columns

Unpivot Column

Unpivot Question

Unpivot

State	Site	Projects	Value
State 1	Site 1	Project 1	10/01/2021
State 1	Site 1	New Date
State 1	Site 1	Status	Completed
State 2	Site 1	Project 2
State 2	Site 1	New Date
State 2	Site 1	Status	Completed
State 3	Site 1	Project 3
State 3	Site 1	New Date
State 3	Site 1	Status	Completed
State 3	Site 1	Project 4
State 3	Site 1	New Date
State 3	Site 1	Status	Not Started