Question Spreadsheet gurus?? (Need to merge 2 sheets without screwing up data)......

[redgtxdi]

Not sure if this is best place for this, but got a couple pricing files for our company that we use to upload into our software.

Most recent update came from vendor differently. We spent a bunch of time literally fixing line-by-line to make as needed last year with similar problem but we don't want to waste all that time again.

I hate spreadsheets....(well, spreadsheet math & code....it's all non-intuitive insanity imho).......but I've been asked if I could help.

2 sheets but not exactly the same items in the exact same order. (close but not quite) I could just copy pricing from the new sheet to the old & recycle, but columns need to correlate so when we upload into our software, things don't get screwed up.

Suggestions??

TIA ~ Red

 

[winr]

what software or such ??

I can ask my roommate, she is a director with a large company and does this all the time




Ricky.

 

[C1]

From your description, what you want/need to do is trivial (unless maybe if the DBes are inordinately huge).

Seems just swapping columns to match your standard or reference (as this is trivial), then merge and auto sort on the column of interest.

One of the reasons why we use a tool like Excel.

 

[ZoeAndersen]

Since you’re dealing with two sheets that aren’t exactly aligned, the goal is to match up the items first, then transfer the new prices. VLOOKUP You can use these functions to match items between the two sheets based on a unique identifier . Once they’re matched, you can pull the new pricing data into the old sheet where you need it. This way, even if the items are in different orders, the pricing will line up correctly.Use a Merge Add-On – If you’re using Google Sheets, there are add-ons like “Combine Sheets” that can help you match up and merge your data more easily. This is handy if you’re not into the nitty-gritty of formulas.Power Query– If you’re on Excel, Power Query is an awesome tool for merging and manipulating data from different sources. You can load both sheets into Power Query, match them on the product code, and output a clean, merged table with all the columns you need.