Excel Compare 2 Columns and align matching data in same row

I have 3 columns of data

Column 1 = Product ID (Main)

Column 2 = Product ID (Extra)

Column 3 = CategoryID

Column 1 & 2 = Have the same set of numbers but some are missing from both.

I need to compare Column 1 and Column 2 and put a blank row if they don't match. If number from Column 2 does not exist in Column 1, then don't the entire column 2 and column 3 row.


Column 1 Column 2 Column 3

60 60 1

61 61 1


63 63 1


72 72 3

Please make sure the when you put a blank row in column 2 that column 3 also follows because Column 2 and Column 3 has to be in the same ROW.

If you have questions please let me know, I'm not sure if I explain this correctly. I need this asap if you can show me you can do this today I will accept and pay.

Taidot: Excel, Visual Basic

Näytä lisää: align matching data excel, excel align columns matching data, excel align columns data, compare excel columns align, align matching columns excel, excel compare align columns, excel match columns align, compare align columns excel, excel align match, excel compare columns data, excel compare row, excel match compare align, align data columns excel, excel align matching data, align match data columns, align matching data excel column, align match columns excel, excel match columns row, align matching data columns excel, excel compare columns align, match align data excel columns, excel columns data match align, match columns align excel, excel align data columns, 2 63 1

Tietoa työnantajasta:
( 54 arvostelua ) Stanhope Gardens, Australia

Projektin tunnus: #4302336

Myönnetty käyttäjälle:


I am ready to start work now. Please check Pm for details. Thank You.

$30 AUD 2 päivässä
(28 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Good day! After reading the project description, im confident that i can do this job. I hope you will consider me for this job and i can start immediately. Top data entry provider Lisää

$69 AUD 1 päivässä
(16 arvostelua)

Hi Project understood and ready to go. Will deliver in few hours.

$30 AUD 1 päivässä
(11 arvostelua)

I can do this! Could you send me the entire file, so I can adjust my proposal accordingly?

$30 AUD 1 päivässä
(6 arvostelua)

Hello sir, Excel and vba expert here, ready to start.

$30 AUD 1 päivässä
(7 arvostelua)

Hi... I would like to apply for the job.

$30 AUD 1 päivässä
(3 arvostelua)

I have the perfect skill for this project. Further Pl see PM.

$30 AUD 1 päivässä
(4 arvostelua)

My team and I have the skills needed to complete this job in a timely and efficient manner. Ready to start today!

$200 AUD 5 päivässä
(1 arvostelu)