duplicating every second row 
Author Message
 duplicating every second row

hi,

I am doing a data import and need to duplicate every row and then change
some data. My file is somethinglike this:
Invoice#    Amount    Invoice Date
100            $100.00   Feb 12-2003
250            $55.00       Jan 17-2003

I need to create

Invoice#    Amount    Invoice Date
100            $100.00   Feb 12-2003
100            $100.00   Feb 12-2003
250            $55.00       Jan 17-2003
250            $55.00       Jan 17-2003

and then add some columns like so:
Invoice#    Amount    Invoice Date            Acct#                    Type
100            $100.00   Feb 12-2003        00-100-00                3
100            $100.00   Feb 12-2003           00-150-00                9
250            $55.00       Jan 17-2003            00-100-00            3
250            $55.00       Jan 17-2003          00-150-00            9

Any suggestions on how to do this mass row insert and copy and then add
additional columns?

thx,
Doug



Mon, 01 Aug 2005 11:09:05 GMT  
 duplicating every second row
hi,

I am doing a data import and need to duplicate every row and then change
some data. My file is somethinglike this:
Invoice#    Amount    Invoice Date
100            $100.00   Feb 12-2003
250            $55.00       Jan 17-2003

I need to create

Invoice#    Amount    Invoice Date
100            $100.00   Feb 12-2003
100            $100.00   Feb 12-2003
250            $55.00       Jan 17-2003
250            $55.00       Jan 17-2003

and then add some columns like so:
Invoice#    Amount    Invoice Date            Acct#                    Type
100            $100.00   Feb 12-2003        00-100-00                3
100            $100.00   Feb 12-2003           00-150-00                9
250            $55.00       Jan 17-2003            00-100-00            3
250            $55.00       Jan 17-2003          00-150-00            9

Any suggestions on how to do this mass row insert and copy and then add
additional columns?

thx,
Doug



Mon, 01 Aug 2005 11:11:17 GMT  
 duplicating every second row
Two methods:

one
do until loop that inserts a new row copies the data
above, and then moves down,
Pros - certain, highly controlled, completes each line as
you go
Cons - slow as a wet week

two
highlight the data, using extend select (xlenddown etc)
and copy the data immediately below the last data line,
then sort the data into place using the invoice No. as the
sort key.
Pros - quicker insertion of data, easier coding
Cons - still need a loop to insert additional data

Your additional data can be added with a do loop using
offset.

Steve

Quote:
>-----Original Message-----
>hi,

>I am doing a data import and need to duplicate every row
and then change
>some data. My file is somethinglike this:
>Invoice#    Amount    Invoice Date
>100            $100.00   Feb 12-2003
>250            $55.00       Jan 17-2003

>I need to create

>Invoice#    Amount    Invoice Date
>100            $100.00   Feb 12-2003
>100            $100.00   Feb 12-2003
>250            $55.00       Jan 17-2003
>250            $55.00       Jan 17-2003

>and then add some columns like so:
>Invoice#    Amount    Invoice Date            

Acct#                    Type

- Show quoted text -

Quote:
>100            $100.00   Feb 12-2003        00-100-
00                3
>100            $100.00   Feb 12-2003           00-150-
00                9
>250            $55.00       Jan 17-2003            00-100-
00            3
>250            $55.00       Jan 17-2003          00-150-
00            9

>Any suggestions on how to do this mass row insert and
copy and then add
>additional columns?

>thx,
>Doug

>.



Mon, 01 Aug 2005 11:28:35 GMT  
 duplicating every second row
Looks like the account # and type is the same in each duplicated row.
You could copy the whole lot and paste all under the existing list
Add the appropriate extra columns
Select the lot and sort alphabetically on column A
Regards
Bill K


Quote:
> hi,

> I am doing a data import and need to duplicate every row and then change
> some data. My file is somethinglike this:
> Invoice#    Amount    Invoice Date
> 100            $100.00   Feb 12-2003
> 250            $55.00       Jan 17-2003

> I need to create

> Invoice#    Amount    Invoice Date
> 100            $100.00   Feb 12-2003
> 100            $100.00   Feb 12-2003
> 250            $55.00       Jan 17-2003
> 250            $55.00       Jan 17-2003

> and then add some columns like so:
> Invoice#    Amount    Invoice Date            Acct#
Type
> 100            $100.00   Feb 12-2003        00-100-00                3
> 100            $100.00   Feb 12-2003           00-150-00                9
> 250            $55.00       Jan 17-2003            00-100-00            3
> 250            $55.00       Jan 17-2003          00-150-00            9

> Any suggestions on how to do this mass row insert and copy and then add
> additional columns?

> thx,
> Doug



Mon, 01 Aug 2005 15:48:55 GMT  
 duplicating every second row
Sorry........... sort numerically of course!
Bill K


Quote:
> hi,

> I am doing a data import and need to duplicate every row and then change
> some data. My file is somethinglike this:
> Invoice#    Amount    Invoice Date
> 100            $100.00   Feb 12-2003
> 250            $55.00       Jan 17-2003

> I need to create

> Invoice#    Amount    Invoice Date
> 100            $100.00   Feb 12-2003
> 100            $100.00   Feb 12-2003
> 250            $55.00       Jan 17-2003
> 250            $55.00       Jan 17-2003

> and then add some columns like so:
> Invoice#    Amount    Invoice Date            Acct#
Type
> 100            $100.00   Feb 12-2003        00-100-00                3
> 100            $100.00   Feb 12-2003           00-150-00                9
> 250            $55.00       Jan 17-2003            00-100-00            3
> 250            $55.00       Jan 17-2003          00-150-00            9

> Any suggestions on how to do this mass row insert and copy and then add
> additional columns?

> thx,
> Doug



Mon, 01 Aug 2005 15:50:34 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. duplicating every second row

2. duplicating every second row

3. Comparison of each row with every other row in a spreadsheet and elimination of duplicates

4. how to delete every second row

5. Deleting every second row?

6. Please - Macro that deletes every second row

7. inserting a row to every second line.

8. re : choose every second row

9. adding every second cell in a row

10. delete every second row


 
Powered by phpBB® Forum Software © phpBB Group