Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADone!
Hello community! Please find attached the file for the solution. I am a beginner so will be continuing to post more :)
To summarise my Approach
1. Used "Text to Columns" to break into columns.
2. Renamed the columns
3. Removed punctuation except for the 'Poem Read Date Column' (will be handled later)
4. Finally used a combination of DateTimeParse and dateTimeFormat to convert the value into the needed output.