Hi,
i have some data with different column from which i wan to make
i am attaching desired output
id name s
1 AMIKACIN S
1 AMOXICLLLIN R
1 AMPLICILLIN S
4 AVELOX R
1 AZTREONAM R
1 CEFIXIME R
1 CEFOPERAZONE/ SULBACTUM S
1 CEFTAZIDIME S
1 CEFTRIAXONE S
1 CIPROFLOXACIN S
1 MEROPENEM R
1 PIPERACILLIN/TAZOBACTAM R
id AMIKACIN AMIK_ss AMOXICLLLIN AMOX_ss AMPLICILLIN AMPLI_ss
1 Done S Done R Done S