Forum Discussion
spread out duplicate values?
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?
*googles VBA*
i didn't know what it was, but i'm happy to give it a try!
the first column will have matchings SKU's grouped together like in the earlier example, so will not appear anywhere else.
see attached image for example,
i've filtered the SKU's high to low, then highlighted the duplicate values so far
