Hi,

I have an Excel spreadsheet that contains a worksheet with a row of names in it, however, the names appear every 4th column so for example the 1st name is in cell BE and the next BH, BL and so on.

I want to create a formula on a another worksheet that creates the same list but without the gaps and one that can be dragged across and updated if a new name is inserted in the 1st worksheet.

I have tired OFFSET but this does not drag across how I need it to as Excel doesn't know I want it to skip columns.

Thanks
MissDB