Help with moving data from cell into a another cell

Spoiler

Hello _ i need help from this community.

I am working with a excel file and need issue i am facing is in Yellow. Desire state is in Green.

In row C5 the full name should be Balance & Compensation Information. However information is getting cut to a different row C6.

Same for C7- C8: full name should be Account Maintenance W/ Chk Return. Return is on the next cell below

Same for C15 - C16: full name is General Account Services Updated

was hoping to use Multi-Row Formula to solve for it. What can i use to reach my desire highlighted in Green? Which is copying Information and any of the words in Red and append them at the end of previous non blank cell.

IF !ISNULL([Service Description]) and ISNULL([AFM Code]) and ISNULL([XYZ Code])
Then [Service Description] + " " + [Row-1:Service Description]
Else [Service Description]
ENDIF

Alteryx Help.PNG

Sample Data set.xlsx

Alteryx Help.PNG

Developer

Tips and Tricks

Accepted answers

The_Rad_Valentina

@HassimDiallo Try this formula in the MultiRow tool

IF isnull([Row+1:AFM Code]) AND isnull([Row+1:XYZ Code]) AND isnull([Row+1:Unit Price])

Then Trim([Service Description]) + " " + Trim([Row+1:Service Description])

Else Trim([Service Description])

ENDIF

The_Rad_Valentina

Here's the workflow, let me know if this solves your question.

Please accept the response as a solution if it does.

Thank you,

Valentina

Solution.yxmd

All comments

The_Rad_Valentina

Here's the formula you should use that will do the trick.

IF Contains([Service Description],"…")

Then Trim(REGEX_Replace([Service Description], "\…\.*","")) + " " + Trim([Row+1:Service Description])

Else Trim([Service Description])

ENDIF

Screenshot 2025-02-03 160047.png

If this works for you, please accept this as a solution.

Solution.yxmd

HassimDiallo

@The_Rad_Valentina , Thank you for the below. This is definitely the idea but not quite. I need to clarify few points.

the ..... (red dots)does not exist in my data. i wanted to show you information highlighted in red needed to be moved where the dots are in order for the correct output to show Balance and Compensation Information.
logic is to only make the change where service description has data and AFM Code and XYZ code are blank the date under [Row+1: service description] should be copied and pasted at the end of [Row+0: Service Description]. IE: Information needs to be copied and merge with Balance & Compensation to make Balance & Compensation Information.
could you please copy your sample data set in a text input file and share sample of workflow again. I wasnt able to run the file because of the input file directory.

Thank you so much and kind regards,

Hassim

The_Rad_Valentina

@HassimDiallo Try this formula in the MultiRow tool

IF isnull([Row+1:AFM Code]) AND isnull([Row+1:XYZ Code]) AND isnull([Row+1:Unit Price])

Then Trim([Service Description]) + " " + Trim([Row+1:Service Description])

Else Trim([Service Description])

ENDIF

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335