How to add the rows based on the Specified column extracted value?

I have to add the row on output based on the column name “Total” Value extraction from the First row.

e.g ,The first row have 2 value from the column name “Total”. So need to create 2 rows &update extracted value in the specified header output.

The Third row have 1 value from the column name “Total” . So need to create 1 rows & update extracted value in the specified header output.

Can someone guide me please. how to do this?

image

image

Hi, @jamuna_T

Can I change table like that;
This is an Excel spreadsheet that outlines a table with three main service categories, each containing items and total values, with some cells highlighted in red. (Captioned by AI)