K Kenshin Member Jan 18, 2018 #1 Hi ninjas sorry to bother you again, but I'm stuck of this problem, for clear explanation please see the file attach thanks Attachments Sample Data.xlsx 14.7 KB · Views: 13
Hi ninjas sorry to bother you again, but I'm stuck of this problem, for clear explanation please see the file attach thanks
GraH - Guido Well-Known Member Jan 18, 2018 #3 Seems do-able with power query (OS Windows 7+; Excel 2010 or +). https://www.microsoft.com/en-US/download/details.aspx?id=39379 Would like this: To get started with PQ... Perhaps start here: https://chandoo.org/wp/2015/07/30/intro-to-power-query-podcast/ https://chandoo.org/wp/tag/power-query/ or on youtube go for ExcelIsFun... Very nice video tutorials. Attachments sample-data-1-wht PQ.xlsx 25.2 KB · Views: 1 Last edited: Jan 18, 2018
Seems do-able with power query (OS Windows 7+; Excel 2010 or +). https://www.microsoft.com/en-US/download/details.aspx?id=39379 Would like this: To get started with PQ... Perhaps start here: https://chandoo.org/wp/2015/07/30/intro-to-power-query-podcast/ https://chandoo.org/wp/tag/power-query/ or on youtube go for ExcelIsFun... Very nice video tutorials.