Move date field up one level and then delete the two empty rows.

Question

here's the problem

Yoshiro_Fujimori · Answer

Hi @55dhr ,

As @Qiu mentioned, you would get responses more quickly if you add a sample imput and its expectd output.

But I created a workflow assuming what you may want.

I hope it helps.

Workflow

Input

DateProduct NameFunctionPrice 2024-04-15       ComcastPhont/Fax/Internet303.31 2024-04-13       abcSoftware/Hardware492.45 2024-04-12       MicrosoftSoftware/Hardware14341.69

Output

DATEProduct_NameFunctionPrice2024-04-15ComcastPhont/Fax/Internet303.312024-04-13abcSoftware/Hardware492.452024-04-12MicrosoftSoftware/Hardware14341.69

1262761.yxmd

Qiu · Answer

@55dhr 
Can you provide a sample input and desired output to help us better understand your question?

Input is better in data format rather than snapshot. 😁

55dhr · Answer

Really need help with this one!