Joining two sheets together.

Hello i would want to join two sheets together in one sheet.
Pretty hard to explain but i will try my best.

I would want to have two rows of A,B,C,D columbs
so the result should look something like this:


A B C D E F G H I J K
1
2
3
4
5
A B C D E F G H I J K
6
7
8
9
Sheet1


Hope that explains it =)

Originally Posted by ChemistB

Nope, it doesn't.

1. Are these two sheets within the same workbook?
2. Are there duplicates between these two sheets that you want eliminated?
3. Are the two sheets set up exactly the same so that all you need to do is copy the data from the second sheet to the first? (In which case, what is the problem?) OR
4. Is there a common column in both sheets so that you want to lookup on sheet #2 what is found on Sheet 1?

An actual example with before and after might help.

1. yes, actually right now they are on the same page..
Let me explain little more of what i am doing.
Im putting describing pictures in 1 row above, for this i use the "1" row.
The pictures have different lenght's so im fitting the pictures to fit with each column.
and under that is text to the picture.
Then it looks like this on a sheet.

___A_|B|_C_ |D|
1|Pic1|Pic2__|
2|text|text__|
3|Pic3__|Pic4__|
4|text__|text__|

So ... well.. hope you understand now.. i would want to make it easyer to make those pages..
i would want it to look like this:
_|_A_|__B__ |
1|Pic1|Pic2__|
2|text|text__|
3|__A__|__B___|
4|Pic3__|Pic4__|
5|text__|text__|

Hope it describes it better :D

Originally Posted by ChemistB

I think I get it but am only guessing because the formatting doesn't show on this forum. Are Pics 3 and 4 (and the corresponding text) in columns C and D? and you want everything brought into columns A and B?

If the picture properties are set to "move but don't size with cell" (which I think is the default), you can select all blank cells and delete them and move cells left. Would that work?

i want to pic1 and 2 to be seperated from pic 3 and 4.. because if i change cells spacing where the pics are of picture 1 then there will be change in the pic 4 :S