How to format the rows?

[Anonymous]

Hi,

I want the rows(Even rows) that contain 'CUSIP:XXXXX' to be in a new column side by to the odd rows. Ex: CUSIP no. of 2nd row with row-1 in new column. How can I do that? and I want to remove only the value(not entire row or column )in column-1&row no.28 'CL A'.

Thanks,

Vishnu

[vinieme12]

Can you mark a response as correct and close the thread please