TRANSFORM First(NSN_BAZLI_ALT_ALTA.CEVAP) AS IlkCEVAP
SELECT NSN_BAZLI_ALT_ALTA.[N-S-N]
FROM NSN_BAZLI_ALT_ALTA
GROUP BY NSN_BAZLI_ALT_ALTA.[N-S-N]
PIVOT NSN_BAZLI_ALT_ALTA.MRC;

 select NSN, 'NAME' as MRC, NAME as Cevap from [NSN_BAZLI_YANYANA]
 union all 
 select NSN, 'AGAV' as MRC, AGAV as Cevap from [NSN_BAZLI_YANYANA]
 union all 
 select NSN, 'CXCY' as MRC, CXCY as Cevap from [NSN_BAZLI_YANYANA]
 union all 
 select NSN, 'ZZZK' as MRC, ZZZK as Cevap from [NSN_BAZLI_YANYANA]