need to transpose the data given in B column

Originally Posted by Giri.hb

Hi Flame,

... what I need is the data given in the b column should be transpose as I given in another sheet ...

Did you also check the last formula in Post #7?

Both Siva's (Post #4) and Post #7 do what you describe.