This is just a snapshot of the data, as I'm not able to post actual full data. There are about 30 different types (beyond what's listed), all with a range of 1 to 105. The actual data has repeated rates, so the merge would be exactly what I need. My only thought was to have a more automated way of separating a large dataset, into subsets and merging them back together by rate. I'm hoping to find a way to do this, without listing each of the different type categories, because they're not static with each run. (i.e. If I run is on test x, the types are reading, writing. If I run it on test y, the types are reading, math, english.) Hopefully this clears it up a bit: I need to change this: Type Rate Count Percent Reading 1 10 Reading 5 11 Reading 8 12 Reading 105 13 Writing, Speaking, And Listening 1 10 Writing, Speaking, And Listening 2 11 Writing, Speaking, And Listening 8 12 Writing, Speaking, And Listening 105 13 To this: Rate Reading Count Reading Percent Writing, Speaking, And Listening Count Writing, Speaking, And Listening Percent 1 10 10 2 . 11 5 11 . 8 12 12 105 13 13
... View more