Thanks! I also messed around using a new column and the INDIRECT feature.
Thanks again for your help

"Herbert Seidenberg" wrote:

Select all data in columns B and C
Insert Name Define Names in Workbook: array_u
Also define these names:
rown Refers to: =FLOOR(ROW()-1,5)/5+1
coln Refers to: =IF(MOD(ROW(),5)=2,1,IF(MOD(ROW(),5)=3,2,3))
Enter this formula into A1 and copy down
=IF(coln<3,INDEX(array_u,rown,coln),"")