aggregating rows of data

[Jill]

I have a table that has two columns of information. The first column contains
an index number. The second column contains information that relates to that
index number. Each index number may be listed up to 4 times, each time with a
different piece of information in the second column.

Column A Column B
Index Number Data
1234 ABCD
1234 EFGH
1234 IJKL
1234 MNOP
5678 ZYXW
5678 VUTS
5678 RQPO
etc.

What I would like to do is create another table with Column A (Index Number)
as the unique identifier, and create 4 columns that contain the supplementary
data.

Column A Column B Column C Column D Column E
1234 ABCD EFGH IJKL MNOP
5678 ZYXW VUTS RQPO
etc

Can such a thing be done in Access?

Thanks!

 

[pietlinden]

I have a table that has two columns of information. The first column contains
an index number. The second column contains information that relates to that
index number. Each index number may be listed up to 4 times, each time with a
different piece of information in the second column.

Column A Column B
Index Number Data
1234 ABCD
1234 EFGH
1234 IJKL
1234 MNOP
5678 ZYXW
5678 VUTS
5678 RQPO
etc.

What I would like to do is create another table with Column A (Index Number)
as the unique identifier, and create 4 columns that contain the supplementary
data.

Column A Column B Column C Column D Column E
1234 ABCD EFGH IJKL MNOP
5678 ZYXW VUTS RQPO
etc

Can such a thing be done in Access?

Thanks!

bad plan. use a crosstab query if you want to do that.