Really need help with this one!
@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. 😁
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
Date | Product Name | Function | Price |
2024-04-15 | |||
Comcast | Phont/Fax/Internet | 303.31 | |
2024-04-13 | |||
abc | Software/Hardware | 492.45 | |
2024-04-12 | |||
Microsoft | Software/Hardware | 14341.69 |
Output
DATE | Product_Name | Function | Price |
2024-04-15 | Comcast | Phont/Fax/Internet | 303.31 |
2024-04-13 | abc | Software/Hardware | 492.45 |
2024-04-12 | Microsoft | Software/Hardware | 14341.69 |