Convert Excel Columns into Rows -

-

please take @ attached snapshot.

table how convert original table required table, in easiest manner ?

here, have shared small sample, real table quite big having more 100 rows / symbols , 100 columns / dates. therefor not possible manually copy paste data change table format. final output table have 3 columns "symbol, date , value" arranged according dates in ascending order.

please suggest how this. thanks

here is. put original table in 1 sheet, sheet1. top left cell being a1 = symbol
go sheet, sheet2.
in cell a1 put: symbol
in cell b1 put: date
in cell c1 put: value

go cell a2 , put formula:

=indirect("sheet1!a" & 2+mod(row()-2; x);true)

go cell b2 , put formula:

=indirect("sheet1!r1c" & 2+rounddown((row()-2)/x;0);false)

go cell c2 , put formula:

=indirect("sheet1!r" &2+mod(row()-2; x)&"c" & 2+rounddown((row()-2)/x;0);false)

in formulas above, replace x number of symbols got. in original table there 4.
now fill down needed
note: if functions don't work, use comma(,) instead of semicolon(;).


Comments

Post a Comment

Popular posts from this blog

What can cause "Required Package 'IndyCore' not found" when compiling a Delphi 2010 project? -

-
i have got fresh install of delphi 2010 on windows 8.1. i create new project, , under packages, select "build runtime packages". i compile , error "[dcc fatal error] e2202 required package 'indycore' not found" i have checked: package indycore140.bpl available in $bds\bin directory other indy related packages. indycore.dcp file available in $bds\lib , $bds\lib\debug. this driving me nuts. hints? this command line when enable "show command line" option (line breaks added readability): dcc command line "project2.dpr" c:\delphi\delphi2010\bin\dcc32.exe --no-config -lurtl;vcl;vclx;vclimg;vclactnband;dbrtl;vcldb;vcldbx;bdertl;vcltouch;xmlrtl; dsnap;dsnapcon;teeui;teedb;tee;adortl;vclsmp;vclie;inet;inetdb;webdsnap; websnap;inetdbbde;inetdbxpress;soaprtl;dbxcommondriver;dbxclientdriver; dbxinterbasedriver;dbxmysqldriver;dbexpress;dbxcds;tdbf;intrawebdb_100_140; intraweb_100_140;indycore;indysystem;indyprotocol...
Read more

Change the color of an oval at click in Java AWT -

-
i have draw ovals in java, , @ click change color. beginning tried change color after 20 ms, doesn't work. my code is: public class mycomponentnew extends frame { public graphics2d g2d; public mycomponentnew(string title) { super(title); setsize(400, 550); } @override public void paint(graphics g) { this.g2d = (graphics2d) g; this.g2d.setcolor(color.red); this.g2d.filloval(10, 55, 50, 100); } public void changecolor () { this.g2d.setcolor(color.blue); this.g2d.filloval(10, 55, 50, 100); } } and in class main method have: mycomponentnew m; m = new mycomponentnew("fereastra cu baloane"); m.setvisible(true); m.addwindowlistener(new windowadapter() { @override public void windowclosing(windowevent we) { system.exit(0); } }); try { thread.sleep(20); } catch(interruptedexception e) {} m.changecolor(); the color of oval remains red. ...
Read more