Matching Item numbers and moving rows

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

First let me just that all of you who take the time to answer these
questions. They really help people out like me!!!!!!!!!!! THANKS

My question revolves around two sets of data containing a common
item# one has product specification and comprises all of my
products(8,000), the other has recent activity with dates of a few
product (630). I would like to put together the data on one line for
a particular item so:

Data Set 1 Data Set 2
Item# Size Cost Item# Date Quantity
1 4 $5 2 3/11/02 6
2 8 $9 4 3/12/03 5
3 1 $3
4 2 $5
5 4 $4

I would like one data set:

Item# Size Cost Date Quantity
1 4 $5
2 8 $9 3/11/02 6
3 1 $3
4 2 $5 3/12/03 5
5 4 $4

Thank you once again to all those that are so helpful!
 
Not sure I entirely understand what you're trying to do, but think that
the 'concatenate' function might be what you want. If you use this
function with dates it will change the dates back to number so you
would have to format the cells as text!

=concatenate(A1,A2) where a1 and a2 are the details you are trying to
accommodate in a single cell.

Alternatively you could use =""&A1&" - "&A2&"" This is useful where
you want to insert hyphens and other text arrow the text you're pulling
in.

Hope this helps.
 
Back
Top