Put modality in column

[Irache]

Hello,

I have a dataset like this :

They have a several Captor in "Captor type" column and I want to transpose this dataset like this :

Date	Temp_Capt_109	Humidity_Capt_109	Temp_Capt_110	Humidity_Capt_119
06/06/2023 15:15:00	20	47	12	55
06/06/2023 15:16:00	20	47.5	12	55

I have already tried to pivot column "Captor type" but it doesnt spread value correctly all value are concentrate in Capt_109 columns :

Someone can help me please.

[BA_Pete]

Hi @Irache ,

This looks like an XY Problem.

What are you actually trying to achieve by doing this? You're moving the data structure away from the most efficient and usable format for Power BI reporting.

Pete