Forum

Thanks Alan , the codes set in PQ [power query], it ok now the layout

How's the status?

Thanks Alan source data attached

or how to use a correct formula to extract

Thanks Jessica you great help ! But what we want the layout from the Pivot table should transpose as below ie rows wise presentation, to show th...

File uploaded, pls help

Will have a go, deep thanks Catalin..

Thanks Philip, sorry late response, will attempt.

Thanks Philip,another brilliant alternative. Normally the data derive from System Report, so the PQ can come in to help transform data, make our Repor...

Thanks Alan, I try it, now the loop become perfect.

Alan, still waiting your suggestion, anyway thanks in advance