Dealing with some tricky excel sheets.. As seen in the attachment, there are 2-3 rows of headers in each column. Notice also that there can be 3 lines given for style number - and I need to collect and concatenate them.
If I was able to get the full style number in the right place, I could probably do something like:
if(mod(RowNo(),3) +1 = 3, <Field>)
to see the remainder /3...
Regardless, I am stumped.. Any help would be much appreciated.