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...
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!
I think I see a problem.
Power Query can certainly handle data of your size.
However, in the screenshot of your result there are several "error" entries.
This is because you have entries with the same Notification and Stat. but multiple dates.
For example:
Here you have the same notification and stat. (E0042) but different dates.
You did not indicate that this was possible, and you have not shown how you would want this displayed.