Forum Discussion
Solved
Change data set structure, unsure how to transform this
I have a dataset that isn't structured ideally. I'm hoping someone can suggest a way to transform this. Current structure has different Gate purpose dates across in columns. Col1text-Projec...
It could be done with Power Query
please see in attached file.
If with formulae it depends on which Excel platform/version you are and how big the source data.
What you propose makes sense in a very general way. Your request for help, though, is hard to meet or satisfy without knowing a bit more. What is the whole database about? You've touched ever so briefly on what might be called the INPUT end of things, and how you want that initial raw data to be stored. What is the desired OUTPUT? Is there any intermediate PROCESS--anything that happens to the initial raw data before we reach the OUTPUT end? And so forth.
In short, you could help us help you by giving more of the big picture.