I have an excel data with below columns
I am trying to fetch Vendor wise data and copy into datatable. I am able to copy only the first row of Vendor data But I need to copy all the rows that comes under one vendor like below
From the above screenshot, I am taking Venor A data. it needs to copy data from A2 to G3
Similarly, for vendor B, I want copy data from B4 to G4
Similarly, for vendor C, I want copy data from C5 to G7
similarly, for vendor D, I want copy data from D8 to G8 and so on…
Please find attached test excel file for your reference.
Test_vendor.xlsx (9.9 KB)
Please suggest me how to do it.