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?
If you could recreate the error with a sample workbook that would be really useful, and would help us solve it a lot quicker!
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
@theyele uncheck 'First Row Contains Data' in the Input Data tool
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?