importing data into alternate rows

  • Thread starter Thread starter oldLearner57
  • Start date Start date
O

oldLearner57

hi community

besides writing macro, is there some way where I can import data, say, 50
rows and have it imported into alternate rows, it can be in even rows or odd
rows

or another task is

after I imported say 50 rows into excel, how or can I create empty rows in
between each
data (the 50 rows that contained the data)

thanks community for enlightening

:)
 
Import data to the first 50 rows. Then in an empty column fill a
sequence 1, 2, 3, etc down to 50. Then highlight the numbers 1 to 50
in that column and copy it directly below the first 50. Then highlight
all 100 rows and do Data | Sort using the helper column as the sort
key - you will get 1,1,2,2,3,3,4,4 etc with a blank row between the
rows of your data. Then you can delete the helper column.

Hope this helps.

Pete
 
great ..! much appreciated for the help...so direct and simple yet....!!!

thanks again Pete_UK

thanks community :)
 
Glad to be able to help again.

Pete

great ..! much appreciated for the help...so direct and simple yet....!!!

thanks again Pete_UK

thanks community :)
--
oldLearner57






- Show quoted text -
Click to expand...
 
Back
Top