Split data and copy surrounding data
Hi,
Another challenge:
I may have, ideally, something like:
Mfg Part Number Qty Price
abc 111222 50 .25
xyz 333554 50 .25
etc. These items may be exactly the same, but are made by different mfg, so
have different part number.
Challenge:
I receive data as follows:
Mfg Part Number Qty Price
abc 111222 50 .25
xyz 333554
where the mfg has been entered in one cell, using Alt Enter and where the
part number has also been entered in one cell using Alt Enter
I need to separate these onto separate rows, but need to copy the qty,
price, etc. onto these lines as well.
I'm fine with adding some columns, using text to columns to divide the data,
but have no idea how to then grab the surround data and repeat it.
Is there any way to do this?
Thanks
--
Thanks!
Dee
|