In the following example, I will be adding the first three columns to an already existing table:
RecordID Line No PersonID Field1 Field2 Field3 Field4
1 1 1 John Smith 2009 Pass 12/2008
2 2 1 Biochemisty MD Rockvillle 20852
3 3 1 Honors
There will be multiple individuals with this format. Not all individuals will have all Line No 1-3 (i.e. a person can have 1, 2, or 3, lines).
The end result will be one table, where each individual (Columns 1 - 3 all equal 1), will transpose the bottom one or two rows (Line No 2 and 3), into Line No 1.
I have not been successful in my initial attempts, in A. auto numbering the first three columns depending on how many rows the individial has (between 1 and 3), and then transposing all rows to one row for the individual.
Assistance with SQL coding is appreciated. Thank you