rooirokbokkie
New member
- Joined
- Aug 28, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi everyone. I'm having some serious issues with a data set from hell. I managed to merge 3 separate excel files using a combination of IF's, VLOOKUP and sacrificing small animals.
But now I'm hopelessly stuck. the data set contains about 5000 students but their marks are organized in rows and not columns. I need it in columns for SPSS to like it. (so it should look like Sheet 2)
However, there are over 450 subjects and I can only use a subject for analysis if there are more than 100 students who took that subject. I need to somehow transpose the subjects and marks into a new sheet but only if the subject count exceeds 100. Essentially it needs to run down column B and D in Sheet1 and if there are more than 100 students that have taken a specific subject then it should write that subject to a new column in a new sheet and allocate the relevant marks to the relevant student number.
So for argument's sake, let's assume that only Accounting, English, Mathematics, Chemistry 171, and Calculus 158 had more than 100 counts in Sheet 1. This produces Sheet2. It can chuck the other stuff out.
I hope i made it clear what the issue is. I would appreciate some help an awful lot as I don't have time to learn VBA in a day.
But now I'm hopelessly stuck. the data set contains about 5000 students but their marks are organized in rows and not columns. I need it in columns for SPSS to like it. (so it should look like Sheet 2)
However, there are over 450 subjects and I can only use a subject for analysis if there are more than 100 students who took that subject. I need to somehow transpose the subjects and marks into a new sheet but only if the subject count exceeds 100. Essentially it needs to run down column B and D in Sheet1 and if there are more than 100 students that have taken a specific subject then it should write that subject to a new column in a new sheet and allocate the relevant marks to the relevant student number.
So for argument's sake, let's assume that only Accounting, English, Mathematics, Chemistry 171, and Calculus 158 had more than 100 counts in Sheet 1. This produces Sheet2. It can chuck the other stuff out.
I hope i made it clear what the issue is. I would appreciate some help an awful lot as I don't have time to learn VBA in a day.