How to arrange two columns like this

Hi there,

I have a table with two columns like these:

1
2
4	1
	3
	2
3
5	4
	5

I need to get it arrange the table like this, the second column should follow the pattern of the first one, it doesn't matter the order, nor the blank spaces, they should remain exactly the same, I need the second column to basically reproduce the first one, of course the same data is in both columns, so it can compare the expressions inside and arrange them that way:

1	1
2	2
4	4
3	3
5	5

The thing is, there are more than two columns, these are 'assigned' to column two like this:

1
2
4	1	some data here	some data here
	3	some data here	some data here
	2	some data here	some data here
3
5	4	some data here	some data here
	5	some data here	some data here

So I'd need not only the second column to be arranged, but also 'its content' which is in the other columns... To achieve this:

1	1	some data here	some data here
2	2	some data here	some data here
4	4	some data here	some data here
3	3	some data here	some data here
5	5	some data here	some data here

How can I do this? I'd highly appreciate any advise,

Regards.

You may try this....

Please Login or Register  to view this content.

and copy across and down.

See the attached.

Hi,
Could you please upload the workbook with sample data....

Hello sktneer
It worked just fine! thank you very much!

And thank you as well Lokesh. Now I have another concern and your advise might be very helpful my friend.

Please guys see the table attached.

I've uploaded a sample workbook with two sheets, one with the issue, and the other one with the result I need,
Any advise?

Thank you.

(Edit: Where the yellow/green rows collide with the other yellow/green rows, certainly that's different data they contain, as shown in the workbook, one contains data for "data1" and the other one for "data2", and so on... So they must autofill only the ones they belong to...)

See the attached.

Thanks! I finally could do it!