matching and aligning columns of data I have a set of data I would like to inser

Question

matching and aligning columns of data

I have a set of data I would like to insert into an existing spreadsheet but the data I need to insert is randomly ordered. The new data contains a column of data which has the same data as I would like to insert, just not in the same order. For example

A B

20100 at 21999 at

22015 at 22056 at

23654 at 20100 at

25698 at 23654 at

22056 at 22015 at

21999 at 25698 at

How do I match and align the data in column A with the data in column B so that they then look like this

A B

20100 at 20100 at

22015 at 22015 at

23654 at 23654 at

25698 at 23698 at

22056 at 22056 at

21999 at 21999 at

any advice would be helpful...

thanks for help !!

Explanation / Answer

Hi,,,

Select column B by clicking the column heaeder then right click any selected cell and click 'Insert' and you get an empty row between A & C..

Put the formula below in b1 and drag down.

=IFERROR(INDEX(C:C,MATCH(A1,C:C,0)),"")

Select column B and right click 'Copy'. Right click again, Paste Special, select 'Values; OK

delete column C.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.