Remove blank rows and columns


I want to remove the first 3 blank rows, 5th blank row and the 1st column. PFA image for reference.

Could you please let me know how to achieve this ?

If the template is always like that, when you use Excel read range, in Range property you add value “B4”, check at Use headers property. You table will start from from cell B4, not whole excel sheet. About that 5th row, you can use Remove datarow. The index of that row should be 0, because your table now start from cell B4

1 Like

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.