G
Guest
I have one file with a column of items and a column of prices. I have another
file with items, monthly sales amounts plus some other information. Because
there's other information, there are 4 rows for each item, but the monthly
sales amount is always the first of the 4 rows. So it looks something like
this
item A jan sales feb sales mar sales
item A info1 info2 info3
item A etc1 etc2 etc3
item A data1 data2 data3
and repeats for item B,C and so on.
I want to end up with sales amounts for the items in the first file. Not all
the items in first file will be found in the second file and vice versa.
I want the final product to be the first file with items and prices and
sales amounts for whichever months I choose, e.g. 6 month period or the whole
year.
file with items, monthly sales amounts plus some other information. Because
there's other information, there are 4 rows for each item, but the monthly
sales amount is always the first of the 4 rows. So it looks something like
this
item A jan sales feb sales mar sales
item A info1 info2 info3
item A etc1 etc2 etc3
item A data1 data2 data3
and repeats for item B,C and so on.
I want to end up with sales amounts for the items in the first file. Not all
the items in first file will be found in the second file and vice versa.
I want the final product to be the first file with items and prices and
sales amounts for whichever months I choose, e.g. 6 month period or the whole
year.