Hello,
I have been struggling quite a bit with what I want to achieve.
My input is a very simple table, like this:
<tbody>
</tbody>
I would like to achieve this table starting from my input table:
<tbody>
</tbody>
I have been trying using Power Query, simple Excel Tables and Array Formulas and other techniques, but I really can't get it out.
Ideally, as the input_table is updated, I would like the output_table to be dinamically updated/expanded as well, through Data --> Refresh All with Power Query or through formulas recalculation with Excel formulas.
Thank you in advance,
Andrea Catalucci
I have been struggling quite a bit with what I want to achieve.
My input is a very simple table, like this:
Type | Value |
A | value1 |
A | value2 |
B | value3 |
A | value4 |
B | value5 |
C | value6 |
C | value7 |
A | value8 |
B | value9 |
C | value10 |
<tbody>
</tbody>
I would like to achieve this table starting from my input table:
A | B | C |
value1 | value3 | value6 |
value2 | value5 | value7 |
value4 | value9 | value10 |
value8 |
<tbody>
</tbody>
I have been trying using Power Query, simple Excel Tables and Array Formulas and other techniques, but I really can't get it out.
Ideally, as the input_table is updated, I would like the output_table to be dinamically updated/expanded as well, through Data --> Refresh All with Power Query or through formulas recalculation with Excel formulas.
Thank you in advance,
Andrea Catalucci