Format Excel

Hi Team,

Please refer to the attached file.

I have data in the format provided under the Data tab. I want to achieve the result as per "result" tab and eliminate all the rows that are not needed. I would like the logic to work dynamically as the data is frequently updated

Thanks

Samp.xlsx

Datasets

Developer

Common Use Cases

Accepted answers

JosephSerpis

Hi @JDong I mocked up a example to tackle this. Using a Multi-Row Tool and some Filters and Select should accomplish this.

Multi_Row_Tool_14122022.yxmd

All comments

JosephSerpis

Hi @JDong I mocked up a example to tackle this. Using a Multi-Row Tool and some Filters and Select should accomplish this.

Multi_Row_Tool_14122022.yxmd

michelle_mathews

Hi @JDong , here's my take on it. Hope it helps!

Example.yxzp

PanPP

Hi @JDong

Another method to achieve the output is attached in the sample WF.

Hope this helps.. If it does, please like the post and mark it as a solution..

Sample WF - Result Tab.yxmd

sireeshagandam

Good

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703