Thread: Combine Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Combine Data

Hello..
How can i do this task?
I want to combine row in sheet1 and sheet 2..
i elaborate below:

lets say in sheet1 i got this data:
1 a a a a a
2 b b b b b
3 c c c c c
4 d d d d d
5 e e e e e

in sheet2 i got this data:
1 f f f f f
2 g g g g g
3 h h h h h
4 i i i i i
5 g g g g g

and i want to combine both data so it become like this
1 a a a a a
1 f f f f f
2 b b b b b
2 g g g g g
3 c c c c c
3 h h h h h
4 d d d d d
4 i i i i i
5 e e e e e
5 g g g g g


please help me....