Consolidate data to produce date

Hi Community,

Currently i would like to format the date after extracting the data (by using text to column) from the file. The date format as belows. May i know how can i build the workflow to combine the data as below to produce the desired result.

Thank you so much in advance.

Date format 2.xlsx

Common Use Cases

Accepted answers

Emil_Kos

Hi @SH_94,

I have prepared a workflow for you:

First I have prepared data and afterwards, I have used the date time parse function to create proper output.

Date Time.yxmd

All comments

Emil_Kos

Hi @SH_94,

I have prepared a workflow for you:

First I have prepared data and afterwards, I have used the date time parse function to create proper output.

Date Time.yxmd

SH_94

Hi @Emil_Kos ,

Thank you for the swift response.

I am very impressed on the way you design the workflow and i have run it in my data. It work well in my case.

Thanks again for your guidance and sharing

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703