Hi,
I have attached my dataset (an Alteryx output - already transformed data) where I have nominal codes in column A. For some of these nominals, I want to duplicate the rows for additional nominals that weren't in my original dataset, keeping the values in columns B-D the same, but updating column A for the additional nominal.
For example, there are currently 81 rows for nominal 50220 - 27 x core, 27 x micro, 27 x indirect, (one for each month Dec23 - Feb26). I want to replicate these rows for nominals 50230 and 50210, each would have 27 rows for each business unit and the 'value' in column D for each month and corresponding business unit would be the same for each nominal. I'd therefore have an additional 162 rows of data.
I know this is straightforward enough to do in excel for just these two, but I have several examples to add and need to do it on a monthly basis using an input that will never have the missing nominals.
How do I go about this?
Many Thanks
