Combine Sheets

[Kenshin]

Hi ninjas sorry to bother you again, but I'm stuck of this problem, for clear explanation please see the file attach


thanks

 

[Deepak]

I think it seems difficult by formula as per the data layout.

 

[GraH - Guido]

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.