Multirow Formula to fill data based on the different column in the workbook

[Neelima1]

if column A contains "7" then in column B one cell down should update with some text.

Can one suggest multirow formula

[Qiu · Accepted solution]

@Neelima1 
A quick sample

[Neelima1]

Hi, 

Thank you for the quick response. Please help with another multi row formula, refer New query sheet in attached the file

[CoG · Accepted solution]

Here is a sample workflow to tackle this new query:

[Qiu]

@Neelima1 

I like the solution from @CoG  😁

[Neelima1]

Thank you 😄  its working.

[CoG · Accepted solution]

If your issue is resolved, please kindly mark helpful responses as Solution, to help others find the answers they are looking for.

Happy Solving!!!

[Neelima1]

Hi @Qiu 

Please help me to write a multi row formula. I need to update the employee code to below rows where the below rows are related to same employee.

In the attached file... Column A is Actual data, I need the alteryx output like data in Column B. 

[Qiu · Accepted solution]

@Neelima1 
thanks for the request 😁
I think the several queries from you are similar, invovling Regexand multi-row formula, and should get you familaried with them now.

[Neelima1]

Thank you @Qiu  😄