HI, I have answered a almost exactly similar question on Quora using VBA
Please see my answer here https://www.quora.com/How-can-I-transpose-column-headers-in-Excel-to-match-row-headers-only-if-a-value-is-present-in-a-corresponding-cell/answer/Dilip-Damle There are other answers to that question. I would use my own VBA for this task. But after the quora question and other answers I learnt that the latest version of excel have UNPIVOT feature which can do the above task. Please google UNPIVOT Regards Dilip Damle You can find me hanging around at this place most often https://www.quora.com/profile/Dilip-Damle On Wednesday, March 29, 2017 at 6:51:59 PM UTC+5:30, Nikhil VJ wrote: > > Hi again, > > PFA a diagram that should explain the desired task more clearly. > > > On 3/29/17, Nikhil VJ <nikh...@gmail.com <javascript:>> wrote: > > Hi friends, > > > > Data re-organizing query : How can we reformat this data (see attached > > excel) so that a visualizer can read it and render it as a graph with > > dates in x-axis? The data is arranged two-dimensionally (rows by month > > and different column for each day) and we need to convert the data to > > a one-dimensional table (sample shown in second worksheet in the > > attachment). There are quite a lot of such tables out there so it > > would be great to know of a programmatic way of achieving this. > > > > > > ---------- Forwarded message ---------- > > From: Abhijeet Kamble <abhijee...@ceeindia.org <javascript:>> > > Date: Wed, 29 Mar 2017 16:00:45 +0530 > > Subject: Fwd: GIS GeoOdk Data > > To: Nikhil VJ <nikh...@gmail.com <javascript:>> > > > > I forget to send you the same.... > > > > May be useful for someone in your network... > > > > > > > > -- > > Abhijeet Kamble > > Project Officer (MGB) > > Centre for Environment Education > > Central Regional Cell > > Pinewood Apartment > > S No 233/1/2, Vidhate Colony, Baner, Pune 411 067 > > Landmark : Ahead of Medipoint Hospital > > URL: www.ceeindia.org > > Phone: 020 - 27298861 / 9922151915 > > Google maplink http://goo.gl/maps/rthpc > > > > > > ~*Water has very sharp memory, it never forget it's path...*~ > > > > > > > > -- > > -- > > Cheers, > > Nikhil > > +91-966-583-1250 > > Pune, India > > Self-designed learner at Swaraj University > > <http://www.swarajuniversity.org> > > Blog <http://nikhilsheth.blogspot.in> | Contribute > > <https://www.payumoney.com/webfronts/#/index/NikhilVJ> > > > > > -- > -- > Cheers, > Nikhil > +91-966-583-1250 > Pune, India > Self-designed learner at Swaraj University < > http://www.swarajuniversity.org> > Blog <http://nikhilsheth.blogspot.in> | Contribute > <https://www.payumoney.com/webfronts/#/index/NikhilVJ> > -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to datameet+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
