In Progress

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.

Example

Column 1 Column 2 Column 3

60 60 1

61 61 1

62

63 63 1

65

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.

Skills: Excel, Visual Basic

See more: align matching data excel, 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 match columns excel, excel match columns row, excel compare columns align, match columns align excel, excel align data columns, excel compare columns, matching data excel, compare exist, excel row column, data compare, 2013 excel visual basic

About the Employer:
( 54 reviews ) Stanhope Gardens, Australia

Project ID: #4302336

Awarded to:

mimirabb

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

$30 AUD in 2 days
(28 Reviews)
4.2

8 freelancers are bidding on average $56 for this job

weblazer

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 www.freelancer.com/d/skills/Data_ More

$69 AUD in 1 day
(16 Reviews)
4.9
satsin7

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

$30 AUD in 1 day
(11 Reviews)
4.2
Uthe2009

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

$30 AUD in 1 day
(6 Reviews)
3.0
farr4u

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

$30 AUD in 1 day
(7 Reviews)
3.0
rohitpithisaria

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

$30 AUD in 1 day
(3 Reviews)
2.9
nmlarsath

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

$30 AUD in 1 day
(4 Reviews)
2.2
joehilton1984

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

$200 AUD in 5 days
(1 Review)
1.4