importing data into alternate rows

[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

 

[Pete_UK]

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

 

[oldLearner57]

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

thanks again Pete_UK

thanks community

 

[Pete_UK]

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 -