output I want is(image):
input given (.xlsx)
ExtractDataTableGenerated.xlsx (8.0 KB)
Note: I want to convert this input excel into the table being given in image
I want the whole input excel(.xlsx) to look like the table you can see in image.
If you’ll see carefully the column headers are repeating but the data is coming correctly in respective columns and rows…except the column 3 whose values are coming last.
It will be a great help