Joining Data

[Devika]

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

[binuacs]

@Devika 

[ChrisTX]

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

[Devika]

@binuacs 

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.   

[binuacs]

@Devika please let me know if the results are not matching

[ChrisTX]

Your desired output listed these 2 rows, which is not Record date 2:

BJMY6G0	2022-03-31
BJMY6G0	2022-03-31

[Devika]

@binuacs 

Hi,

Im not getting the same output as yours 

[binuacs]

@Devika I don't see any date fields in your file. Please check th input file