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
273 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:dallagmm
  • 2
4 Comments
 
LVL 13

Expert Comment

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

Author Comment

by:dallagmm
Comment Utility
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
Comment Utility
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:dallagmm
Comment Utility
very good
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
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.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now