Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
BA_Pete
Super User
2 years ago

Hi 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks everyone for your help. 
    I have been able to get all the dates to be in one column using the split code from Subash_Govind. 
    I will now work on the data to see how far I can get. It's been a jpourney trying to get an already produced data to be a raw data kind of.