hi. basic macro question.
i have data that fills into column a. i want to take this the first 10 rows and spit out the data onto r1c2 seperated by commas for example: data1,data2,data3, to data10. then on row2column2:data11,data12,data13..........then r3c2, r4c2, rowetc-c2 until its all grouped into rows of ten seperated by commas.
This seems like it should be easy. my brains just not working right now.
Thanks!