I have an excel sheet in which I have the data for a few stocks and I need to create the Line Charts for them. But the data first needs to go through 2-3 stages, in order to arrange it properly for plotting the line charts.
First the data comes into Raw Data Sheet from external source. Then it gets converted into Pivot Table Format. And then it is moved to third sheet, where data for every single symbol gets arranged properly. And then finally in the forth step, the line charts gets created.
I have confusion in the 3rd sheet. How do I properly move the data from the pivot table to this third sheet in such a manner that all the data gets arranged properly under each symbol name, on a daily basis ?
I have explained the requirement in very clear and detailed manner in the attached sample file.
Please suggest various methods by which this could be done.
If you have any doubts, then please ask them, and I would explain in more details.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
All I am trying to do is to find a method by which data for specific column could be picked up from the Pivot Table and then it can be copied to FIXED CELL LOCATIONS in the adjoining sheet.
Something similar to doing the Vlookup type of thing. But this time we are picking up the data directly from pivot table, so I am not sure what method to be used.
If anyone want more explanation, then kindly ask, I will explain in as much detail as possible. Please give it a shot, have a look at the sample file. It is not as complicated as it looks :)
Thanks a lot