Format User ID by Date in a proper format

[g7777]

I want to display USER ID and Date in a proper format
Here is the input data which is already provided



and this is the output which I want

 

[pecoflyer]

Please post a sample sheet so we can work on it. Thanks

 

[g7777]

Please post a sample sheet so we can work on it. Thanks

data.xlsx

drive.google.com

 

[pecoflyer]

Can't open your file
Is this a Googlesheet question?

 

[g7777]

Can't open your file
Is this a Googlesheet question?

Yes

 

[g7777]

NOW open it I have posted the excel file

 

[pecoflyer]

Unable to open. Maybe someone else will have more luck - Good luck with your query

 

[shrivallabha]

NOW open it I have posted the excel file

The attached file is corrupt. Please reupload a new sample.