Incremement Row Segment by Numeric Successor

[Porialex]

So I have an csv file that I need for a database migration that I have to reformat from rows to columns.

The process takes segments from a single user's record like this:

12 15 15 12 12

And organizes them like this:

12
15
15
12
12

This is because the various pieces of data are supposed to be in the same category of data. Now, I have successfully transformed one row into columns (16, to be exact) and I figured all I had to do was use the the auto-fill tool to finish the 5000 or so records that follow. But when I try to increment the block, I get references from row A1 going directly to the corresponding rows, such as A18, instead of to the next row, A2.

So, I simply want the blocks to increment their rows by 1, uniformly, instead of use the current row for the starting block. Does anyone know how to do this?

[Special-K]

Give us a bigger sample of your data and what you want it to look like when processed.

[Porialex]

Three original records:

[Student] | [Spring 2008 Hours] | [Fall 2008 Hours]
Student 1 | 12 | 15
Student 2 | 12 | 12
Student 3 | 12 | 15

Should be copied to this format:

[Student] | [Semester] | [Year] | [Hours]
Student 1 | Spring | 2008 | 12
Student 1 | Fall | 2008 | 15
Student 2 | Spring | 2008 | 12 (Student 3 copies here if I were to use the auto-fill tool.)
Student 2 | Fall | 2008 | 12
Student 3 | Spring | 2008 | 12
Student 3 | Spring | 2008 | 15

If I start with the first two rows involving Student 1, and dragged it down, the next segment would copy student three because of it's placement on the rows instead of student two.

[Porialex]

Three original records:

[Student] | [Spring 2008 Hours] | [Fall 2008 Hours]
Student 1 | 12 | 15
Student 2 | 12 | 12
Student 3 | 12 | 15

Should be copied to this format:

[Student] | [Semester] | [Year] | [Hours]
Student 1 | Spring | 2008 | 12
Student 1 | Fall | 2008 | 15
Student 2 | Spring | 2008 | 12 (Student 3 copies here if I were to use the auto-fill tool.)
Student 2 | Fall | 2008 | 12
Student 3 | Spring | 2008 | 12
Student 3 | Spring | 2008 | 15

If I start with the first two rows involving Student 1, and dragged it down, the next segment would copy student three because of it's placement on the rows instead of student two.

This doesn't really matter now. I found a round about (and very tedious) way of doing it in which you give each new organized row it's own set of columns and then use the auto-fill tool. Everything fills out correctly, row after each row.

[aydeegee]

Hi Porialex

Sorry I did not see this earlier

Perhaps the attached might help the alleviate the tedium next time?

Regards
Alastair