Another option, place this in any starting cell, say in B3:
=OFFSET(FK6,,ROWS($1:1)-1)&OFFSET(G6,,ROWS($1:1)-1)&OFFSET(GQ6,,ROWS($1:1)-1)
Copy B3 down
--
Max
Singapore http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.