Under Name1 on sheet 3, something like this should work:

=IF(Sheet1!A1<"", Sheet1!A1, "")

If Sheet1 A1 is empty, then do nothing, otherwise put in here what is in
cell A1.



"Sri" wrote:

Hi..

I have data in 2 sheets which i want it to be displayed in the third sheet.
Please suggest me how to proceed with this...

------**------

Example :
Sheet 1: Sheet 2 :

No Name1 No Name2
1 abc 1 efg
2 eds 2 xyz
4 def 3 aaa
5 dss 6 ddd

The Result should be :
Sheet 3 :
No Name1 Name2
1 abc efg
2 eds xyz
3 aaa
4 def
5 dss
6 ddd

-------**--------