Forum Discussion
Power Query unpivot or anything that can solve the problem
Hi All, I have the data below and I want to separate the date data from other figures so as to have a separate date column. What is the best way to achieve this? I'm stuck in power query trying t...
Thanks Subash_Govind and BA_Pete,
I have been able to get it to work to some extent but still having issue with it.
The issue that I have is that it is only transposing the very first row. If you look at my first example data, you will notice that after % collected, it would start another header with different dates. Those dates are what I'm trying to put together in one column and not just the first row dates.
BA_Pete
Super User
Super UserHi Anonymous ,
It seems that Subash_Govind and AlienSx really want to help you on this, so I'm going to leave it with them now.
All the best 👍
Pete