Good Afternoon,

I opened a CSV file in one worksheet with each row containing information I want to format in a specific way. So, I created a second worksheet and made a format (so that 5 of the rows data fits on one sheet - contains names and addresses for company records). Now, I used the formula, ='CompanyA'!A2 for example to link to field C1 in the new spreadsheet, ='CompanyA'!B2 in field B2, etc up to field A7 in the new sheet (so essentially, all the data in one row (row 2) is transfered over to the new spreadsheet in different rows and columns formatted in a block of info.

Now...when I select the rows (to maintain the formatting) and then try to autofill, instead of it going to ='CompanyA'!A3, ='CompanyA'!B3, etc...it's jumping to ='CompanyA'!A10', ='CompanyA'!B10 etc.

No matter how I try to autofill it, I can't get it so each new record in the spreadsheet pulls from the next line, it keeps jumping values.

Anyone know how I can move the data over to the new format without skipping rows in the source csv?