Code to move one or more values from column and substitute the number by respective category value

[Moraes86]

Hi guys,

I am trying to move the values from column "lot" according to each category in different columns A, B and C, according to respective category (A, B or C)

Each column A b and C has the number of the Lots but I would like to substitute the amount of category A (for example 2) by the corresponding Lot ( example Lot 123 and 321).

You can see the attach filed and please let me know how I could create this code

Thanks,

Daniel

[ballardw]

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.

[Reeza]

Is it ever possible to have values in multiple columns of A, B or C?
Is it only 3 possible categories or will this need to scale to more columns/values?