Format table

Hi Everyone
I have a little problem, and I need your help.
I have a Excel Datei Like this

the Excel Datei: Neuer Ordner.xlsx (636.2 KB)

And I want Like This
The number hot, how often comes the Binnes area in an hour

Thank you very much
Vielen Dank,
ich brauch euren Hilfe

Hi @Anass,

take Excel Reader (XLS) and Pivoting node.


  • Groups -> DateAndTimeValue_string
  • Pivots -> Zykluszeit, Istwert [s] [Binned]
  • Manual Aggregation -> esp. Zykluszeit, Istwert [s]

Best regards


Thank you very much Andres_Steel :+1:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.