spread out duplicate values?

[gareth humphreys]

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! :)

[#2]

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?

[#3]

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!

[#4]

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? 

[#5]

*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