Dear All
I have tabel employee:
ID Letter No Employee Name Employee No 1 223 Jack 01 2 223 Allan 02 3 223 Smith 03 4 224 Jack 01 5 224 Rudy 04 6 225 Ivan 05
and I want to Combine some records with the same of letter No into one row..
how to do like table below..?
Thank You..
Letter No Employee Name1 Employee No1 Employee Name2 Employee No2 Employee Name3 Employee No3 223 Jack 01 Allan 02 Smith 03 224 Jack 01 Rudy 04 225 Ivan 05