I need to fill a column with a value based on a single row

[aberthiaume]

I need to fill a column based on one rows value.  This row is an aggregate based on a measure code.   I took a screen shot of the current set up.  I was thinking of using the create rows tool, but I cannot figure out how to do that based on a condition.  So basically in the example is one measure but I have several measures.  The value in the row is for the ADE measure only.  So for all dates for that particular measure I need to fill it with the Basline information that is in one row. I hope that makes sense.  I am having a hard time articulating the question.  

[binuacs]

@aberthiaume Can you provide the data in an excel sheet also expected output result?

[FloraF]

Hello, 

you can use a multi-row formula to solve this. I attached a screenshot a sample workflow for your convenience. 

If you have multiple columns that you'd like to do the same manipulation for, then you can use a transpose tool, then the multi-formula tool 

**If this solves the issue, please click on the like below" thank you!**

• Happy Solving

[aberthiaume]

Attached is current output and a second file with expected output 

There are a lot of dates.  The date that holds the data I am looking to push to all rows within a measure code is 1/1/2022.  For the example I used two measure codes, to show the difference.  

Thank you for reviewing for me.  

[FloraF]

Hi, 

You are able to do so by the multi field formula, you can select the group by, there are couple of steps that has to be done before that though; such as: filtering the data and then sorting. You may add a union after the manipulation to bring in the historical data and stack on top of the 2022 data. Please see the attached file. 

**If this solves the issue, please click on the like below" thank you!**

• Happy Solving

[aberthiaume]

when I union them back together it just creates the same issue.  

[Christina_H]

This seems like a good use for an append tool, or join if you have different values for different accounts.  Filter out the rows with the data you want, then join or append it to all rows.  I've also used a unique tool since you have more than one row for the same date.