Insert text in column B1 keeping the data in A1-A10

[Ken]

My problem is the date is in column A1-A10 and my batch inserts data starting in column B11. Is there a way the data can be inserted starting in column B1 keeping the existing data in A1-A10 using a batch file? I have dates in column A and I need the inserted text to be inserted into column B1-B10 etc...

Thanks
Ken

[trebor68]

Please see the code block:

Code: Select all

echo 1,2,3,4,5,6,7,8,9,10,11,12,13>Test.csv
echo ,,,,,,,,,10,11,12,13>>Test.csv

You can see the difference between the two rows.
In row 2 you will have not value in the B1-B9.

Please test this.

[Ken]

Thanks for the quick response... This is what it I am having a problem with.
The date will always be in column A and my input text needs to start on the same line as the date in column A.
This is what it is doing.
8/29/2011
1 2 3 4 5 6 etc...
8/29/2011
1 2 3 4 5 6

This is the way I want it to look.
8/29/2011 1 2 3 4 5 6
8/29/2011 1 2 3 4 5 etc.

Thank you for your help
Ken