User Profile
dpwhitey1
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Re: How to pivot Multiple Columns
Here is some sample data ID Milestone Actual Completion Date Actual Start Date Active Activity Status 105610934 Milestone 0 2023-02-22 2023-02-22 No Completed 105610934 Milestone 1 No Not Started 105610934 Milestone 1.1 2023-02-26 No Completed 105610934 Milestone 1.2 2023-02-26 Yes In Progress 105610934 Milestone 1.3 No Not Started 105610934 Milestone 1.4 2023-02-26 Yes In Progress 105610934 Milestone 2 No Not Started 105610934 Milestone 2.1 No Not Started 105610934 Milestone 2.2 No Not Started 105610934 Milestone 2.3 No Not Started 105610934 Milestone 2.4 No Not Started 105610934 Milestone 2.5 No Not Started 105610934 Milestone 2.6 No Not Started 105610934 Milestone 3 No Not Started 105610934 Milestone 3.1 No Not Started 105610934 Milestone 3.2 No Not Started 105610934 Milestone 3.3 No Not Started 105610934 Milestone 3.4 No Not Started 105610934 Milestone 3.5 No Not Started 105610934 Milestone 3.6 No Not Started 105610934 Milestone 4 No Not Started 105610934 Milestone 4.1 No Not Started 105728888 Milestone 0 2023-02-23 Yes In Progress 105728888 Milestone 1 No Not Started 105728888 Milestone 1.1 No Not Started 105728888 Milestone 1.2 No Not Started 105728888 Milestone 1.3 No Not Started 105728888 Milestone 1.4 No Not Started 105728888 Milestone 2 No Not Started 105728888 Milestone 2.1 No Not Started 105728888 Milestone 2.2 No Not Started 105728888 Milestone 2.3 No Not Started 105728888 Milestone 2.4 No Not Started 105728888 Milestone 2.5 No Not Started 105728888 Milestone 2.6 No Not Started 105728888 Milestone 3 No Not Started 105728888 Milestone 3.1 No Not Started 105728888 Milestone 3.2 No Not Started 105728888 Milestone 3.3 No Not Started 105728888 Milestone 3.4 No Not Started 105728888 Milestone 3.5 No Not Started 105728888 Milestone 3.6 No Not Started 105728888 Milestone 4 No Not Started 105728888 Milestone 4.1 No Not Started 105744750 Milestone 0 2023-02-23 2023-02-23 No Completed 105744750 Milestone 1 No Not Started 105744750 Milestone 1.1 2023-02-23 No Completed 105744750 Milestone 1.2 2023-02-23 2023-02-23 Yes In Progress 105744750 Milestone 1.3 No Not Started 105744750 Milestone 1.4 2023-02-23 2023-02-23 Yes In Progress 105744750 Milestone 2 No Not Started 105744750 Milestone 2.1 2023-02-23 Yes In Progress 105744750 Milestone 2.2 No Not Started 105744750 Milestone 2.3 No Not Started 105744750 Milestone 2.4 No Not Started 105744750 Milestone 2.5 No Not Started 105744750 Milestone 2.6 No Not Started 105744750 Milestone 3 No Not Started 105744750 Milestone 3.1 No Not Started 105744750 Milestone 3.2 No Not Started 105744750 Milestone 3.3 No Not Started 105744750 Milestone 3.4 No Not Started 105744750 Milestone 3.5 No Not Started 105744750 Milestone 3.6 No Not Started 105744750 Milestone 4 No Not Started 105744750 Milestone 4.1 No Not Started 105744917 Milestone 0 2023-02-23 2023-02-23 No Completed 105744917 Milestone 1 No Not Started 105744917 Milestone 1.1 2023-02-23 No Completed 105744917 Milestone 1.2 2023-02-23 2023-02-23 No Completed 105744917 Milestone 1.3 No Not Started 105744917 Milestone 1.4 2023-02-23 2023-02-23 No Completed 105744917 Milestone 2 No Not Started 105744917 Milestone 2.1 2023-02-23 Yes In Progress 105744917 Milestone 2.2 No Not Started 105744917 Milestone 2.3 No Not Started 105744917 Milestone 2.4 No Not Started 105744917 Milestone 2.5 No Not Started 105744917 Milestone 2.6 No Not Started 105744917 Milestone 3 No Not Started 105744917 Milestone 3.1 No Not Started 105744917 Milestone 3.2 No Not Started 105744917 Milestone 3.3 No Not Started 105744917 Milestone 3.4 No Not Started 105744917 Milestone 3.5 No Not Started 105744917 Milestone 3.6 No Not Started 105744917 Milestone 4 No Not Started 105744917 Milestone 4.1 No Not Started32KViews0likes4CommentsHow to pivot Multiple Columns
Hello Is there an easy way to use Power Query to pivot data with a Unique ID spread over multiple rows, into a spreadsheet with one row per ID? eg I have 22 milestones below, each milestone has 7 values columns. How do I pivot the milestone column 7 times to create 154 columns in each unique ID row? eg I need it to display like this, as this data needs to be merged with an existing legacy excel report Do I need to duplicate the milestone column 7 times, then pivot each milestone duplicate against each value column? If so is there an easy way to rename each new column to "Milestone 0 Active", "Milestone 1 Active" etc without having to manually rename 154 columns? Thanks very muchSolved32KViews0likes6Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.