Hi guys
I am trying to organize some data in excel. I have arranged it, as I would like.
Each sample has two intervals. Those intervals should be written on separate sheets, but each sample should be written underneath the previous sample. (On both sheets).
Sheet a (interval 1)
Sample x
Sample y
Sample z
Sheet b (interval 2)
Sample x
Sample y
Sample z
Thus far, I can create sheet a and b and place the intervals correctly, but my samples overwrite each other, so I only end up with the values from my last sample.
How do I avoid, that it overwrites my lines and just write them underneath each other?
I reckon this is rather basic, but I am stuck at the point.