Transpose dataset

[#1]

Hi,

I have a dataset which includes shares in 24 columns and drugs in one column. i want each drug in each column and shares in one column. how can i achieve this? pls help. thanks

[CELAMBARASAN]

Hi,

     Try with using Crosstable.

     Drug must be first column.

     If it didn't help explain it with some example?

Celambarasan