One interp & a formulas play ..

In Data,

Put in A1's formula bar, then array-enter the formula
(press CTRL+SHIFT+ENTER):

=IF(ISNA(MATCH(TRUE,B1:G1<"",0)),"",INDEX(B1:G1,M ATCH(TRUE,B1:G1<"",0)))

Copy A1 down to say, A10
to cover the max expected extent of data in cols B to G

Col A will return the leftmost populated cells from cols B to G

Then in Report,

Put in G1: =IF(Data!A1="","",Data!A1)
Copy down to G10

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JPG" wrote:
In Worksheet Data, I have an unpopulated column 'a' and 6 columns 'b' through
'g' which may have data in all or only one of the columns.
I would like to copy the 1st 10 bits of data from the 1st of columns 'b'
through 'g' that is populated.
Then I would like to copy the resulting data in column 'a' from Worksheet
Data to column 'g' Worksheet Report.
Many thanks
jpg