Remove blank rows and columns

[Aishwarya (Aishwarya Srinivasan)]

Hi,

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 ?

[DinhDQ2 (Duong Dinh)]

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