View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Executor Executor is offline
external usenet poster
 
Posts: 74
Default Convert 1 row of data to columns

Hi Mohony,

I suggest the following appraoch:

Using columns F:J for the split info.
F1 = "ABL"
G1 = "AGL"
and so on

For F1 use the formula
'If($C2=F$1,F$1,"")

And copy this formula to the columns F:J for als the used rows.

HTH.

Wouter.