Dynamic table

Hello and good afternoon to all my friends

I have in a table the values corresponding to the year 2024, I wanted the
values in a table so that I can work with these values, I have a correct
result when I do not use a table, with the table it did not work.

Could you help me?
Thank you

Hi leovilla,

Using Power Query you can easily reshape the data into the format you're after (see Sheet1). The table is refreshable after you have amended any data on the 'F Caixa MO24' tab.

I hope this helps.

Snook

Hello, good afternoon, thank you very much for your help, it was very valuable, I did it using power query and the result was great
Thank you

I made a new query if you can help me

Hi leovilla,

You're welcome, I'm happy to help. It looks like alansidman has already responded to your other query, so you're in safe hands.

Snook