Link to home
Start Free TrialLog in
Avatar of miller75
miller75Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Combine fields based on ID

I need to combine a field in my table based on the id, for example

ID              Code
APP001DL11XX      1820
APP001DL11XX      2224
APP001DL11XX      2628
APP001DL11XX      3032
APP001DL11XX      3436
APP001DL11XX      3840
APP001PPFCXX      24
APP001PPFCXX      26
APP001PPFCXX      28
APP001PPFCXX      30
APP001PPFCXX      32
APP001PPFCXX      34
APP001PPFCXX      36

Needs to end up like this with a | separating each piece of data

ID                             Code
APP001DL11XX      1820|2224|2628|3032|3436|3840
APP001PPFCXX      24|26|28|30|32|34|36

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Bhadauria
Saurabh Bhadauria
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of miller75

ASKER

Excellent Thanks