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 thought you wrote your problem was that you had more columns. This screenshot still only shows three columns. I don't see how it is helpful for your second issue.
What happened when you tried my suggestion?