View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ravinder.ingu@gmail.com is offline
external usenet poster
 
Posts: 1
Default splitting one column into rows depending on the data in the column

i have some text data in a single column in the following manner
there is a condition number and some data say d1 d2 d3 d4 ..
d100etc..followed by it(data is also numeric).. the condiotion numbers
are in ascending order..and may vary from 1 to 200..
i want the data to be in different columns( the column number being
the condition number)
and the entris in the column should be the data items (d1 d2 d3...)