Set union of different 'datetime' columns

Hello guys,

I got a dataset in excel which I imported as a table. There are a plenty of parameters in it with each parameter has its own time column. I also selected all time columns as datetime-variables.

My goal now is to bring all the time columns together in order to have one time column and a plenty of parameter columns that are still on their refering time point. Plotting of this modified dataset would be way nicer than before.

How do I achieve this goal?

Thank you for your help in advance!

Kind regards, Spacey

Answer 1

[Guillaume]

If understood correctly, you have several columns which are datetime and you want to regroup them in just one column.

In that case, use stack.

Answer 2

[Spacey]

That helped! Thanks a lot!