Hi!
I'm not really sure how to best describe this problem in the title, but the problem I have is to convert a vertical list of dates and values to a more horizontal one as in the attached example.
I have looked around in the forums to find a solution, there were some similar questions but none that really helped me solve this case. I would be extremely grateful for any help with this, as you probably have noticed im a novice and just can't seem to get this right.
Thanks in advance!
Using Power Query which is available to you as an Excel add in for 2010, here is the Mcode
Attached is the workbook with this transaction. If you are unfamiliar with PQ and Mcode, click on the links in my signature. In later versions of Excel, this is already built in.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you so much for the quick reply!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks