Hi there guys i really hope you can help me with this problem!
I dont think its that difficult to solve but i just cant wrap my head around it.
I have a large dataset from an experiment and I need to perform some statics analysis, but to do that I need to group the data by the samples.
The experiment is a sensory evaluation with 6 samples rated in 5 categories by a total of 64 people. So the sample numbers are repeating. The first column is the sample number, and next ones are scores from the different categories.
excelhelp.PNG
I want to group the data so I got 1 column for each sample and the responses for a category underneath like this:
excel goal.PNG
Then i can just make a sheet for each response.
Is there any macro that could copy the value of cell to the right of any cell with value '211' then i could paste it all in one column. Then i could do that for each of the sample numbers.
Bookmarks