Issue with range input

[Justanotheruser]

Hi,

Am using a dynamic input to bring in a range, say $C5:D31

When i check the data it is bringing in null columns before, any ideas how to stop this?

[FinnCharlton]

@Justanotheruser 

If you could recreate the error with a sample workbook that would be really useful, and would help us solve it a lot quicker!

[theyele]

I think I'm seeing something similar - I'm wanting to import a range from excel, specifically starting from A4.

But when I put this range in, the input tool isn't starting with A4 - it's starting with A2! 

Do you know why it might be doing this? Unfortunately I can't just say "start import on line 4' - I need to specify A4 (as the first column is blank, and the input tool automatically tends to ignore it). 

EDIT: If I switch the File Format to "Microsoft Excel Legacy (.xlsx)" is imports from B4 - a slight improvement, lol

[nagakavyasri]

@theyele uncheck 'First Row Contains Data' in the Input Data tool

[theyele]

Thanks @nagakavyasri - unfortunately I need it to import the "weekXX" row as data, and have "F1", "F2" etc as the headers. Is there a way?