This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 71%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Hi group.
I need your help on how I could, starting from the "data" table, fill in the "result" table.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365 Pro Plus with Power Pivot and Power Query.
Added PivotTable for easy visualization.
With PivotChart and Slicer.
Updated links.
Excel 365 with Power Query.
Transform to rows.
No formulas, no VBA macro.
https://www.mediafire.com/file/atcknkucil0agrk/10_15_22.xlsx/file
https://www.mediafire.com/file/ei7bu5pwbx37ux8/10_15_22.pdf/file
Hi @jm saf
Please refer to HerbertSeidenberg-6295's suggestion.
Any issues, you can let us know.
Hi HerbertSeidenberg-6295
Thanks for your answer and for your time but i don't have Powe Query.
Do you know any way to do it with formulas?
Regards