How do I insert a blank line below each row of known data ？

Question

How do I insert a blank line below each row of known data and have the value equal to the previous row and the GL Account equal to a fixed value？

For example,

Existing data

GL AccountAmount69012000255.4769014000102.7269031000358.196903100038.83

Target data

GL AccountAmount69012000255.4724508210255.4769014000102.7224508210102.7269031000358.1924508210358.196903100038.832450821038.83

CoG · Accepted Answer

An alternative, simple solution that meets the stated requirements:

Depending on need and variability, modifications could be made to make it more intuitive to set the fixed GL Account value, but this should suffice as a starting point.

The point of this workflow is to minimize redundant work. Since all of the amounts already exist and we only need to duplicate the record with an updated field, we can perform a self-Union, using a Formula Tool to update the GL Account Field. Everything else in the workflow is for formatting.

Hope this helps and Happy Solving!