Hi.

Excel 2010.

We have a dataset of several thousand rows looking something like below:

Method = ping
Title = Jalla
egenskap1 = hi
egenskap2= bye
egenskap3=banana

Method = ping
Title = something
egenskap1 = hei
egenskap2= hadet

Method = ping
Title = else
egenskap1 = hei
egenskap2= hadet
egenskap3=banana
egenskap4=mustard
egenskap5=ketchup

Short explanation: each group og rows describes an entity. We wan't to "normalize" these data, in other words, create a record/row for each entity. The union of all key-value-pairs will constitute the columns in the resulting sheet.

The problem is that the number of key-value-pairs describing each entity varies. My first thought was to search for a key-value-manipulating function that also could detect the next intance of the entity: the criteria would be the next occurence of the string Method.

Any pointers?