thanks buddy
i used indirect and it was a big circus for me
this is cool but complex used it now and got results
for future trying to decode and understand
i have all records in first row consisting of 7 fields i would like them to see in 7 columns each. all records in column A R1 means record 1 F1 means field 1 R1F1 means field one of the first record
r1f1
r1f2
r1f3
r1f4
r1f5
r1f6
r1f7
r2f1
r2f2
r2f3
r2f4
r2f5
r2f6
r2f7
this has...