Forum Discussion
transforming excel sheet in power query editor
I am new to power query editor. I have an excel sheet with three columns, Notification, Stat., and Date. Each column has 1311 rows. I want the notification column to stay where it is. I need all 1311...
ronrsnfld
Super User
Super UserHard to tell for sure without the data and expected outcome wrt the extra rows (and your screenshot is virtually useless to me in that regard), but it might be as simple as adding those other three column to the "key" argument. Basically you would group by all the columns except "Stat." and "Date". See if that works. If not, you'll need to provide more detail.
...
#"Grouped Rows" = Table.Group(#"Changed Type", List.RemoveMatchingItems(Table.ColumnNames(Source),{"Date","Stat."}), ...Provided is a screenshot of the email from my boss:
Screenshot of Data, plus another 1000 and some entries, each column has 1310 entries:
Screenshot of the format my boss gave me that they wanted:
Thank you for being so patient, you have been so helpful!