Organize table by column from other table

[Sharkapuno]

Hello guys,
I have two tables that I have to organize together.

Example:
1111 aaaa a1a1a1 - - - 1111 aaaa a1a1a1
2222 bbbb 2b2b2b - - - 3333 cccc 3c3c3c
5555 ffff 5f5f5f - - - - 6666 gggg 6g6g6g

Automatically organize like this:
1111 aaaa a1a1a1 - - - 1111 aaaa a1a1a1
2222 bbbb 2b2b2b
- - - - - - - - - - - - - - - 3333 cccc 3c3c3c
5555 ffff 5f5f5f
- - - - - - - - - - - - - - - 6666 gggg 6g6g6g

How can I organize the two tables in one by comparing the first column?

[oeldere]

Maybe I can’t help you (enough) with your problem, but:

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

[Sharkapuno]

It doesn't work, I can't attach file or picture...

[Sharkapuno]

Ok. Solved.
Just found a way with VLOOKUP function.
Thanks.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.