Challenge #53: Parsing Report Formatted Data

[JamesCameron]

My Effort - Text to Columns and an Iterative Macro

Spoiler

Flow

Macro

[danicahui]

Spoiler

[KaneG]

The key to make my solution work was using one of the common techniques in Dynamic Workflows.

Text to Columns (Split to Rows)

Tile for Sequence Number

Spoiler

[nini]

Only a little different for id=31211967, clienttimeprop is 1.83870967711935E instead of  1.83870967711935E-

[Ivyin702]

please find the attached solution file

[wdavis]

Solution attached!

[JonathanW]

Solved!

Spoiler

[Nicholas_Bignell]

https://youtu.be/FJoQ04lOHwo

[dashakir1]

Thanks GeneR.