Forum Discussion
spread out duplicate values?
hi all, please help, i have data (SKU'S)
one sku suits multiple machines
sku is in column A, machine is in column B
| 60030 | 2.884-535.0 |
| 60030 | 5.765-032.0 |
| 60030 | 6.415-296.0 |
how do i move data from b2 to a3 and c2 to a4 etc etc leaving just the one SKU in column A and the machines it fits in columns b,c,d?
hope that made sense, it's probably really easy, but i have no idea! :)
4 Replies
Hello,
sorry, but the cell addresses don't make sense. From C2: isn't C2 empty, as per your data layout? Why would you want to move B2 (machine) to A3 (overwrite a SKU with a machine name)? Can you mock up an example of the expected result and explain the logic in words?
hi, thanks for your response:
here's the example:
what i have:
60030 2.884-535.0 60030 5.765-032.0 60030 6.415-296.0 what i want to make it:
60030 2.884-535.0 5.765-032.0 6.415-296.0 i have hundreds like this, and need to automate it.
thanks!
Hi again,
thanks for posting the example. I think in your question you confused the columns and rows. The letter points to the column and the number points to the row, so A3 is actually the third row in column A, not the third column in the first row. That was where I could not follow your reasoning.
What you want to achieve is actually not trivial at all. You will need VBA programming to achieve that.
Will the data be sorted by SKU? Or will the same SKU be anywhere in the first column?
Are you comfortable with a VBA solution?
