topic Re: Merge columns with corresponding dates in Discussions

Merge columns with corresponding dates

MahaRabeh — Sat, 10 Jun 2023 23:42:24 GMT

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!

Re: Merge columns with corresponding dates

txnelson — Tue, 11 Jan 2022 18:02:59 GMT

Use

Tables=>Stack

and specify a Multiple Series Stack

Re: Merge columns with corresponding dates

MahaRabeh — Wed, 12 Jan 2022 10:29:22 GMT

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:

Re: Merge columns with corresponding dates

txnelson — Wed, 12 Jan 2022 10:59:37 GMT

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

Re: Merge columns with corresponding dates

MahaRabeh — Thu, 13 Jan 2022 10:57:10 GMT

Thank you! It works