Convert Multiple (Matrix and 3 columns) to 5 columns List.

[user29383902]

Hey guys, I've been trying to convert this data into 5 columns, unfortunately it's more than one matrix in the sheet. and they are all formatted the same. power query pivot table only converts one table at a time and cannot add . the 5 column list will be in a new sheet on the same workbook. and after all possible results have been outputted for the first matrix, it should continue that way until it exhausts the rows in excel. this can happen every 26 rows. as that is the format. where data is missing in the data tab. it should input "0"


the matrix and 3 columns end in AC. while the 5 column list table begins in AE and ends in AK. with an empty column in ah. the data in AE AF and AG, was repeated. the actual data will be from the table and not repeated. i will greatly appreciate any help guys.

 

[Peter_SSs]

As you have been told before

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Is there an EXCEL Formula or VBA macro for Converting Multiple Matrix tables in one worksheet alongside 3 columns to a 5 columns List table?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

I have also sent you a direct message about this. Please check your messages.