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
280 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
[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
  • Learn & ask questions
  • 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

717 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