Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reformating data- how to delete alternate blank rows quickly | Excel Discussion (Misc queries) | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Importing data into multiple rows | Excel Discussion (Misc queries) | |||
Importing data from several fles with different subset of rows | Excel Discussion (Misc queries) | |||
How to sum-up alternate rows ? | Excel Worksheet Functions |