Reading data from excel & segregate it in different excels according to groups


I want to read data from excel sheet where 1 single sheet is containing consolidated data of multiple groups, separated by 1 empty row.

I want to segregate group data in different excels according to groups.

How to achieve it in Process Studio?

Please guide on this.

Attaching sample excel having same format.SampleExcelInput.xlsx (9.9 KB)

Is there an answer to this problem ?
I have similar task to be done, my excel contains three sections, I want to read and process each of the three sections separately.
A sample of my excel is attached(refer Sheet MR)
MR_SR.xlsx (20.9 KB)

@NipunA if the location at the sheet is always the same I think you can achieve this by using VBScript excel commands where you can set the range to get values from.

but how do I assign the values of a range to a variable, that I can use in further steps of my Workflow.

for e.g.
in the ‘Execute VB Script’, I write
projNum = objExcel.ActiveWorkbook.Sheets(1).Range(“C2”)

now how can i use projNum in the next step (Web Set Value) in my workflow ?