Solved

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

Posted on 2014-04-03
4
278 Views
Last Modified: 2014-04-13
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
Comment
Question by:Mohammed Dallag
  • 2
4 Comments
 
LVL 13

Expert Comment

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

Author Comment

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

Regards,

Dallag
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 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

by:Mohammed Dallag
ID: 39997163
very good
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question