Forum Discussion

Stev_data's avatar
Stev_data
Frequent Visitor
4 years ago

Merge randomised row data

Hi,

I have an output from a database which is random with poorly aligned columns and row data. I want to align it into ordered form as shown in link

Current

 

 

Expected Result 

 

Here is the link showing the raw data as against the final desired result

https://docs.google.com/spreadsheets/d/e/2PACX-1vQl4__7u-xSYUuEPMYFjED7jMVeqYTdVNiaHeNY7UyaYrBOBs7IcYb4GL7BVdkCLmNMW8sgnVSwmaWT/pubhtml?gid=2084255122&single=true 

Need Help
Tips and Tricks

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    This is likely possible but, given the input data, there isn't going to be a short answer or single technique that will solve this. In other words, this is more of a small project than a single question.