B
baz
I am using a vlookup to grab some data from a master list. My vlookup
works fine but here is the dilemma:
I am using a sheet that has retail items down the rows and divisions
where certain items are authorized. Each item has various information
including UPC numbers, which I am using for my vlookup. The
dilemma/problem/@#!$%%$#@ is that in several instances there may be
two or three lines of the item listed. What I get is say three rows
with the same UPC but different points of distribution. Obviously the
vlookup will only find the first instance of the UPC and give me back
the values in that row.
I am wondering if there is a way to (easily/automated) combine all
rows of those instances resulting in one row with all of the
distribution points in that row so I could get a correct readout.
EG: The distribution points are A, B, C, D, E, F, G, H, I, J and
across the top in individual columns. All rows have the same UPC
(biggest unique identifier)
Row A3 shows an "x" in A, and F
Row A4 shows an "x" in B, C, D, G, H, and I
Row a5 shows an "x" in J
I want one row amalgamating all of the rows into one row so my vlookup
will pull data from that and be credible.
Please post or respond to bzemcik<no Spam>at<no Spam>yahoo dot (k)om
The email for response from this posting is bogus to prevent Spam.
Thanks,
baz
works fine but here is the dilemma:
I am using a sheet that has retail items down the rows and divisions
where certain items are authorized. Each item has various information
including UPC numbers, which I am using for my vlookup. The
dilemma/problem/@#!$%%$#@ is that in several instances there may be
two or three lines of the item listed. What I get is say three rows
with the same UPC but different points of distribution. Obviously the
vlookup will only find the first instance of the UPC and give me back
the values in that row.
I am wondering if there is a way to (easily/automated) combine all
rows of those instances resulting in one row with all of the
distribution points in that row so I could get a correct readout.
EG: The distribution points are A, B, C, D, E, F, G, H, I, J and
across the top in individual columns. All rows have the same UPC
(biggest unique identifier)
Row A3 shows an "x" in A, and F
Row A4 shows an "x" in B, C, D, G, H, and I
Row a5 shows an "x" in J
I want one row amalgamating all of the rows into one row so my vlookup
will pull data from that and be credible.
Please post or respond to bzemcik<no Spam>at<no Spam>yahoo dot (k)om
The email for response from this posting is bogus to prevent Spam.
Thanks,
baz