Hi,

I've been using this function to transpose records from a single column (A)
to several columns:
=INDEX($A:$A,(ROWS($1:1)-1)*6+COLUMNS($A:B)-1)

All the records were 5 lines with one blank separating each record. The new
file I've received has records that range from 4 lines to 6 lines with a
blank separating each one. How do I work with records of differing sizes?
Do I need a macro now?

Libby