Excel - Reorder merged rows inside column

[Thilina_Rubasingha]

Hi,
I have excel report file and I need to reorder the merged rows inside one column.
I have upload the example image for this.

Requirement.
Fist row don’t need to change.
Others rows need to upside down(as seen on image)

Can anyone guide me to fix this.

Thank you very much

[J0ska]

Hi,
I suppose the only way is to read cells you need to re-order into a datatable (using ReadRange activity), reorder and write back in appropriate order (using WriteRange or WriteCell activity).

Cheers

[Thilina_Rubasingha]

@J0ska Thank you very much for the reply. Do you have any idea about fixed the 1st record position and upside down the rest of the records. I’m try with datatable but still I’m unable to find a logic on this

[Shubham_Varshney]

@Thilina_Rubasingha

Can you share the excel sheet… As far I understand all you need is to get the records on a single line like CASH and soo on right???

[Thilina_Rubasingha]

@Shubham_Varshney

This is the excel file
2.xlsx (13.4 KB)

Yes I need it as single lines and that part is completed. But for the automation need to process last record first in the merged row :). And first record is need to remain same position for the calculations.

[J0ska]

Could you also share the “to-be” state of the excel.
Cheers

[Thilina_Rubasingha]

@J0ska

to-be

I didn’t get it, what exactly you want

[J0ska]

You provided a sample excel “2.xlsx” - I guess this is what you currently have.
Could you also provide another sample showing the desired result?

Cheers

[Thilina_Rubasingha]

Hi @J0ska I have attached the excel with desired result. That column added after the column that need corrections and new desired output column highlighted in green color.

2_After_Correction.xlsx (13.6 KB)

Thanks

[J0ska]

And here you are…
ReorderMergedRows.zip (38.2 KB)

To use in your project you need to read this HOWTO: Use MS Office COM interop with UiPath

Cheers

[Thilina_Rubasingha]

Thank you very much @J0ska you saved my day.
It worked like a charm.
I’m really appreciate your effort.

[J0ska]

Welcome!