求 SQL 合并的有关问题，

求 SQL 合并的问题，急急急
我有这样的一组数据

NULL NULL 368bc947-1c49-463f-a612-f1731d05d90d 氨苄西林
40d19a4c-758f-4992-90a2-f1b9569f78bc青霉素类 40d19a4c-758f-4992-90a2-f1b9569f78bc 青霉素类
4d59154b-09e4-4413-836a-09b34651f589阿莫西林 4d59154b-09e4-4413-836a-09b34651f589 阿莫西林
e5ba770f-5374-4340-bbff-cfcaa2e81203药物处方集 NULL NULL


我希望得到 得到下面的数据 怎么实现啊 求大侠指导  

368bc947-1c49-463f-a612-f1731d05d90d氨苄西林
40d19a4c-758f-4992-90a2-f1b9569f78bc青霉素类
4d59154b-09e4-4413-836a-09b34651f589阿莫西林
e5ba770f-5374-4340-bbff-cfcaa2e81203药物处方集

[解决办法]

SQL code

--> 测试数据：[test]if object_id('[test]') is not null drop table [test]create table [test]([A1] varchar(50),[A2] varchar(10),[A3] varchar(50),[A4] varchar(8))insert [test]select null,null,'368bc947-1c49-463f-a612-f1731d05d90d','氨苄西林' union allselect '40d19a4c-758f-4992-90a2-f1b9569f78bc','青霉素类','40d19a4c-758f-4992-90a2-f1b9569f78bc','青霉素类' union allselect '4d59154b-09e4-4413-836a-09b34651f589','阿莫西林','4d59154b-09e4-4413-836a-09b34651f589','阿莫西林' union allselect 'e5ba770f-5374-4340-bbff-cfcaa2e81203','药物处方集',null,nullselect *from(select [A1] as BH,[A2] as NAME from [test] unionselect [A3],[A4] from [test])awhere BH is not null/*BH    NAME368bc947-1c49-463f-a612-f1731d05d90d    氨苄西林40d19a4c-758f-4992-90a2-f1b9569f78bc    青霉素类4d59154b-09e4-4413-836a-09b34651f589    阿莫西林e5ba770f-5374-4340-bbff-cfcaa2e81203    药物处方集*/