Excel Automation, split Row based on column value

[harsha.purushothama]

Hi team,

I have a query to resolve
, the scenario is - I have data in excel stored horizontally - i need to split or divide it based on the specific value(at value “Data Souce”)

here, the start column Name is “Tree structure code” and ends with “Data Souce”

I need to split these table data into one after the other

required Solution: i need the below tables vertically means one table after the other

[PaviS (Pavithra S)]

Just to confirm, will the tables always start at the same cell in the documents?

[harsha.purushothama]

Hi Pavithra,
Thanks for the Response.

Tables will not start at the same cell, it’s dynamic.

these tables also could be many numbers, which are horizontally sorted in Excel.