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...
I'm reasonably sure you don't really want to do this (in power query at least).
If you did do it and if you want do anything with those new columns, you'll have to write a measure for each column => 1311 measures.
Also, what happened to row with Notification 300642957?
HotChilli,
The row with notification 300642957 would be moved below the first notification. Atleast, that is what my boss wants.
| Notification | E0002 | E0042 |
| 30054015 | 1/24/2024 | 01/17/2024 |
| 300642957 | 5/22/2024 | 1/5/2024 |
What does it mean to write a measure for each column?