Merge specific columns from different SKU sheets?

Hazel

Hi,

I am an amazon seller, unfortunately, information like total stock, stock shipped, product cost, customer returns etc are scattered across many different reports which I have to download in XL format and then manually, copy the information from one XL sheet to the other for each corresponding SKU (I have 120 SKUs) which is a nightmare of a task. Is there software that can merge specific columns from different XL sheets into one using the SKU name as a unique identifier?

Steven

I think first you have to get them in order so they all match each other.

Hazel

Steven how do I do this? Can you give me some steps?

Support from Sheetgo

@Hazel on each of your spreadsheets, create another helping tab that gets the columns in order.

On that helping tab, use the query formula to reference to original tab.

https://support.google.com/docs/answer/3093343?hl=en