Copy Value to Multiple Fields

[HopeCQ]

Hello,

I'm trying to copy numeric values from one field to multiple fields. Specifically, I'm trying to copy values under field 2023 to the same record/row for Jan-2023 thru Dec-2023 fields. Is this possible using Alteryx without inserting new fields and formulas for each month?

[Qiu · Accepted solution]

@HopeCQ 
We can first use transpose tool to bring the Jan-2023 thru Dec-2023 fields to vertical then assign value from "2023" then use Cross Tab to bring the target fields back to horizontal.

[AndrewDMerrill · Accepted solution]

You can use the Generate Rows Tool and then Cross Tab the result:

[HopeCQ]

These are both excellent solutions, thank you both for taking the time to help!!

[Qiu]

Glad to help😁