View Single Post
  #2   Report Post  
 
Posts: n/a
Default

If you can settle for 2 Col, try this:
In the first Col enter the letter alone
In the second Col enter this formula
=A2&COUNTIF(INDIRECT("a"&ROW()&":"&"a1"),A2)
change the addresses as needed
Ilan