How can I change the Excel sheet format (water) in the attached Excel file to the final sheet

Dear All,

How can I change the Excel sheet format (water) in the attached Excel file to the final sheet.

Regards,

Dallag
test123.xlsx
Mohammed DallagPetroleum ConsultantAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Enter this formula in A2 and copy it down and across

=INDEX(Water!$A$2:$ZZ$304,IF(COLUMN()=1,1,MOD(ROW()-2,COUNT(Water!A:A))+2),IF(COLUMN()=2,1,INT((ROW()-2)/COUNT(Water!A:A))+2))
0
 
Santosh GuptaCommented:
pls explain more.... unable to understand, what do you want.
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
I need the first sheet to be converted to the second sheet.

Regards,

Dallag
0
 
Mohammed DallagPetroleum ConsultantAuthor Commented:
very good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.