J
jonno
Hi,
I have two list of products in the following format:
LIST 1
PROD ID PRICE
0998552 £1.04
0998553 £1.10
0998963 £2.95
0997542 £3.60
0997544 £9.60
LIST 2
PROD ID PRICE
0998963 £3.50
0998552 £1.50
0997544 £9.80
0998553 £1.50
0997542 £3.90
Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. Any help greatly appreciated.. Each list
contains approx 400 products.
Thanks in advance for any help!!
Jon
I have two list of products in the following format:
LIST 1
PROD ID PRICE
0998552 £1.04
0998553 £1.10
0998963 £2.95
0997542 £3.60
0997544 £9.60
LIST 2
PROD ID PRICE
0998963 £3.50
0998552 £1.50
0997544 £9.80
0998553 £1.50
0997542 £3.90
Both lists are in a different order, I need to transpose the prices
from list 2 to another column on list 1 so that the price matches the
PROD ID in each list. Any help greatly appreciated.. Each list
contains approx 400 products.
Thanks in advance for any help!!
Jon