I am an Access beginner and would like to find out how to change lines
into columns. This is what my imported table looks like (this is only
one record of the table)
Field1 Field2
PT J
CR BAK SP, 1974, J TRAUMA, V14, P187
BONE LB, 1989, J BONE JOINT SURG AM, V71, P336
BUTTENSCHOEN K, 2000, J TRAUMA, V48, P918
CHAMPION HR, 1995, J TRAUMA, V38, P94
ELMARAGHY AW, 1999, J BONE JOINT SURG A, V81, P1155
GEBHARD F, 1997, SHOCK, V7, P313
GEBHARD F, 2000, ARCH SURG-CHICAGO, V135, P291
GIANNOUDIS PV, 1998, BRIT J SURG, V85, P986
GORIS RJA, 1982, J TRAUMA, V22, P895
GORIS RJA, 1985, ARCH SURG-CHICAGO, V120, P1109
HIKI N, 1995, J TRAUMA, V38, P794
HISANO S, 1997, CYTOKINE, V9, P447
KROHN CD, 1999, EUR J SURG, V165, P101
KROPFL A, 1999, J ORTHOPAED RES, V17, P261
MILZMANN DP, 1992, J TRAUMA, V3, P236
NASTKOLB D, 1997, J TRAUMA, V42, P446
OBTACKE U, 1998, SHOCK, V10, P7
OESTN HJ, 1985, UNFALLCHIRURG, V88, P465
PAPE HC, 1993, J TRAUMA, V34, P540
PAPE HC, 1999, J TRAUMA, V46, P907
PARSONS PE, 1989, AM REV RESPIR DIS, V140, P294
PULLICINO EA, 1990, LYMPHOKINE RES, V9, P231
ROUMEN RMH, 1993, ANN SURG, V218, P769
SAKAMOTO K, 1994, CYTOKINE, V6, P181
SMEJKAL R, 1991, CHEST, V100, P667
STRECK W, 1993, UNFALLCHIRURG, V96, P433
STRECK W, 1999, J TRAUMA, V47, P358
SVOBODA P, 1994, J TRAUMA, V36, P336
WAYDHAS C, 1992, UNFALLCHIRURG, V95, P67
WOLFF G, 1978, UNFALLHEILKUNDE, V81, P425
YAMADA T, 1998, WORLD J SURG, V22, P783
SN 0020-1383
J9 INJURY-INT J CARE INJURED
JI Injury-Int. J. Care Inj.
SC Critical Care Medicine; Emgency Medicine; Surgy
UT ISI:000187224400001
and so on....... same Field 1 comes back but with different Field 2
info
I would like to change the Field 1 data (PT, CR, SN, J9, J1, SC, UT)and
then under each column add the Field 2 information. I would like the
new table to look like the following:
UT SN J9 SC CR PT
ISI:... 0020-1383 INJURY-.... Critical.. BAK SP.... J
ISI:... 0020-1383 INJURY-.... Critical.. BONE.... J
So each CR line will still have its one line but with the same info in
the other fields. The SN, SC, PT fields will of course chance with the
records further down in the table. What I want to do is later on to
search for the CR fields and match it with another table.
I guess I have to creat a macro to perform this? Please can anyone help
me with this?
Pau