Format Excel

[JDong]

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

[JosephSerpis · Accepted solution]

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

[michelle_mathews]

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

[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..

[sireeshagandam]

Good