How to move data from an excel cell to unspecified number of rows

Help Studio
, , ,
2

Hi @parimala.prata

Can you try this

The image shows a detailed UiPath workflow for processing data between Excel sheets, including copy-pasting ranges, reading and replacing values, filling ranges, writing cells, and deleting sheets. (Captioned by AI)
The image shows a detailed UiPath workflow for processing data between Excel sheets, including copy-pasting ranges, reading and replacing values, filling ranges, writing cells, and deleting sheets. (Captioned by AI)648×3153 176 KB

Input:

The spreadsheet lists invoices from Wells Fargo and BOA along with vendor names, totals, and counts, but includes a discrepancy with additional numbers below the counts. (Captioned by AI)
The spreadsheet lists invoices from Wells Fargo and BOA along with vendor names, totals, and counts, but includes a discrepancy with additional numbers below the counts. (Captioned by AI)718×592 11.1 KB

Output:

This spreadsheet lists invoices and totals for Wells Fargo and BOA, along with counts for each institution. (Captioned by AI)
This spreadsheet lists invoices and totals for Wells Fargo and BOA, along with counts for each institution. (Captioned by AI)676×556 11.2 KB

Sequence.xaml (35.0 KB)

Regards,