Do you just mean

=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

--
HTH

Bob Phillips

"Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:519B554A1A7AE@OfficeKB.com...
>
> Hi All,
>
> How do I Index a Row of Text values in one Sheet and Return the Text data
to
> a NEW Sheet in one Column?
>
> Sample - Row of Text data - Sheet 1
> Columns B C D E
> RowNo. 1 41-42 50-51 55-56 59-60
>
> If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
>
> Expected Results - returned in Column A - New Sheet
> Column A
> RowNo.8 41-42
> RowNo.9 50-51
> RowNo.10 55-56
> RowNo.11 59-60
>
> Thanks
> Sam
>
>
> --
> Message posted via http://www.officekb.com