I'm looking for a way to combine an Acct# column for all records that have the same ID#.
Record ID# Acct#
1 7 0001
2 7 0020
3 8 0032
4 8 1111
It doesn't matter if the Acct#'s get put together in one field
Record ID# Acct#
1 7 0001 0020
or if a new field is created for each instance
Record ID# Acct# Acct#1
1 7 0001 0020
Any suggestions would be appreciated greatly.
Have a good one.
Record ID# Acct#
1 7 0001
2 7 0020
3 8 0032
4 8 1111
It doesn't matter if the Acct#'s get put together in one field
Record ID# Acct#
1 7 0001 0020
or if a new field is created for each instance
Record ID# Acct# Acct#1
1 7 0001 0020
Any suggestions would be appreciated greatly.
Have a good one.