Hi,
I apologize if my title did not accurately represent my problem, but the image below illustrates my issue:
imgur: the simple image sharer
Basically, I am working with a large set of study data, and I need to pare it all down to a single row per study entry. As you can see in the image above, the data that I downloaded parsed the data so that several of the categories create a repeated entry in a new row. What I'm hoping to do is have excel move the items highlighted in green up to be in line with the large red line. If the other items below the green highlight moved too, then that would be fine, but they are less important.
Any help would be appreciated.
Thanks.
I apologize if my title did not accurately represent my problem, but the image below illustrates my issue:
imgur: the simple image sharer
Basically, I am working with a large set of study data, and I need to pare it all down to a single row per study entry. As you can see in the image above, the data that I downloaded parsed the data so that several of the categories create a repeated entry in a new row. What I'm hoping to do is have excel move the items highlighted in green up to be in line with the large red line. If the other items below the green highlight moved too, then that would be fine, but they are less important.
Any help would be appreciated.
Thanks.
