X
xm
Hello,
I have a .csv file I load into Access. The file contains the same ID
multiple times, but with a different VAL. Is it possible to combine
the values from the VAL fields, so each ID only occurs one time, and
then put the data into a "new" table as shown below.
Table content after loading the .csv file
ID VAL
10 A
10 B
11 S
12 M
13 T
13 K
14 Q
15 O
16 P
Desired table content
ID VAL
10 A, B
11 S
12 M
13 T, K
14 Q
15 O
16 P
Currently I have a macro doing this in Excel, but I would like to
avoid this step completely, if possible.
I have a .csv file I load into Access. The file contains the same ID
multiple times, but with a different VAL. Is it possible to combine
the values from the VAL fields, so each ID only occurs one time, and
then put the data into a "new" table as shown below.
Table content after loading the .csv file
ID VAL
10 A
10 B
11 S
12 M
13 T
13 K
14 Q
15 O
16 P
Desired table content
ID VAL
10 A, B
11 S
12 M
13 T, K
14 Q
15 O
16 P
Currently I have a macro doing this in Excel, but I would like to
avoid this step completely, if possible.