Hello, Please help me to join the below data INPUT SedolRecord date2Record date3Record date471088992022-03-292022-03-292022-03-2940319762022-05-162022-05-16 B1L95G32022-11-012022-11-01 0287580 2022-12-23 BJMY6G0 2022-03-31 BJMY6G0 2022-03-31 BH6XZT52022-03-24 2793115 2022-03-242793115 2022-03-24 Output SedolRecord date 71088992022-03-29 40319762022-05-16 B1L95G32022-11-01 02875802022-12-23 BJMY6G02022-03-31 BJMY6G02022-03-31 BH6XZT52022-03-24 27931152022-03-24 27931152022-03-24

Joining Data

Hello,

Please help me to join the below data

INPUT
Sedol	Record date2	Record date3	Record date4
7108899	2022-03-29	2022-03-29	2022-03-29
4031976	2022-05-16	2022-05-16
B1L95G3	2022-11-01	2022-11-01
0287580		2022-12-23
BJMY6G0		2022-03-31
BJMY6G0		2022-03-31
BH6XZT5	2022-03-24
2793115			2022-03-24
2793115			2022-03-24


Output
Sedol	Record date
7108899	2022-03-29
4031976	2022-05-16
B1L95G3	2022-11-01
0287580	2022-12-23
BJMY6G0	2022-03-31
BJMY6G0	2022-03-31
BH6XZT5	2022-03-24
2793115	2022-03-24
2793115	2022-03-24

Workflow

Tips and Tricks

Accepted answers

All comments

What are your data prep rules? For the first row, all three Record date values are the same. Should these 3 values always be the same? Which value do you want if they are different?

Devika

Hello Chris,

It would be Record date2 that would be needed

ChrisTX

Here's a starting point.

Chris

Joining Data.yxmd

Devika

@binu_acs

Hello Binu,

Can you help me use the transpose tool for the attached sheet in similar way where i will get the Record date in one column instead of 3 different columns.