Organize data in a series of columns

[Dinossaralho]

Hello!

I don't know how to explain my question in the title so I'm sorry, I'm very noob with excel xD
I have a datasheet with 3 columns (date, parameter, value) but I have 7 different parameters like (ozone, temperature, humidity, etc) and I want to arrange the data in a way that I have a column for each parameter. How can I transfer the value and date of each parameter that way?

I have the sample file.
On the left, the first 3 columns it's the file that I have, on the right is how I want to make the file.
If you need translation I can do it.

Thank you so much in advanced!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[Dinossaralho]

Thank you so much for the reply! I added the file now.

[AliGW]

Unfortunately, I think you missed this bit in the instructions:

... and some manually calculated results.

This means you need to manually mock up some examples of what you wish to achieve. Do that and attach the workbook again, please.

[Dinossaralho]

Yes, I'm sorry I missed that part! I uploaded the sample again . Thank you for your patience with me

[AliGW]

The attached solution uses PowerQuery. I loaded the source table to connection only, then created summary tables by referencing the master query and filtering.

This is all dynamic: if you edit the source table, hit Refresh All on the Data tab and your summary tables will update, too.

[Dinossaralho]

YES! Thank you so much for your help that was exactly what I needed! Thank you once again <3

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.