Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

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

Posted on 2014-04-03
Medium Priority
283 Views
Dear All,

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

Regards,

Dallag
test123.xlsx
0
Question by:Mohammed Dallag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 13

Expert Comment

ID: 39974553
pls explain more.... unable to understand, what do you want.
0

Author Comment

ID: 39974566
I need the first sheet to be converted to the second sheet.

Regards,

Dallag
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 39974668
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

Author Closing Comment

ID: 39997163
very good
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
Suggested Courses
Course of the Month9 days, 18 hours left to enroll