importing data into alternate rows
 

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

:)
--
oldLearner57

importing data into alternate rows
 

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

On Apr 22, 3:37*pm, oldLearner57
wrote:
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

:)
--
oldLearner57

importing data into alternate rows
 

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

thanks again Pete_UK

thanks community :)
--
oldLearner57


"Pete_UK" wrote:

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

On Apr 22, 3:37 pm, oldLearner57
wrote:
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

:)
--
oldLearner57

importing data into alternate rows
 

Glad to be able to help again.

Pete

On Apr 22, 4:40*pm, oldLearner57
wrote:
great ..! much appreciated for the help...so direct and simple yet....!!!

thanks again Pete_UK

thanks community :)
--
oldLearner57



"Pete_UK" wrote:
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

On Apr 22, 3:37 pm, oldLearner57
wrote:
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

:)
--
oldLearner57- Hide quoted text -

- Show quoted text -