Merge columns with corresponding dates

[#1]

Hello,

What is the best way to merge 3 group of columns (Example below: 1 column "Group", 3 columns "events", 3 columns of respective dates) into 3 columns with the list of all events attributed to each group and corresponding dates? This is only an example, i am looking for a solution to address big number of rows. Thanks!

[#2 · Accepted solution]

Use

     Tables=>Stack

and specify a Multiple Series Stack

[#3]

Hello,

Thank you for your reply.

I tried the stack function with multiple series, it seems to not work as my columns are different data type:

[#4 · Accepted solution]

I suspect that you mistakenly specified the "Number in the Series" incorrectly.  It should be specified as 2.  See below

[#5]

Thank you! It works