Categories
User Help

How do I normalize/flatten en Excel row with multiple values in single rows with single values?

original data

I have an Excel sheet where my user has counted the number of animals observed during her flight. I have to find a way to split her input into multiple rows where only one animal type is on each row. From the example, you can see that she saw 5 animals (of 2 types) associated with that day, flight line and waypoint (i.e. columns A-E) –> what I need to do is display that using 2 lines as there are 2 entries on the original row. Finally, there are 36 columns that can contain count values and around 9000 original rows to go through.

I am not proficient in VBA at all. If you Folks could point me in the right direction, I should be able to hack something together.

Thanks Layne

Leave a Reply

Your email address will not be published. Required fields are marked *