We may need a bit more specifics.....
but here are a couple of ways....
You can simply point to the first cell, then copy across.
e.g. =Sheet1!A1 and copy across.
or
=INDEX(Sheet1!1:1,COLUMNS($A$1:$A1)) copied across.
where Sheet1 is sheet you have the data in.
Bookmarks