Copy Value to Multiple Fields

Question

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 Answer

@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.

CoG · Accepted Answer

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