PC Review


Reply
Thread Tools Rate Thread

cut and past matching string

 
 
=?Utf-8?B?Sm9vdGpl?=
Guest
Posts: n/a
 
      21st Sep 2007
I have some massive data in a sheet and want to shift information from one
row or multiple rows to another row behind the information in that row. I
have this kind of information in the sheet:


[bestandnaam]=d2000-1458.txt [woorden]=5861 [zinnen]=161 [regels]=679
[bestandnaam]=d2001-0024.txt [woorden]=3764 [zinnen]=93 [regels]=445
496 21 68 Sole Panelist
506 21 69 Sole Panelist
3754 93 441 Sole Panelist


Where ' bestandnaam' , ' woorden' , 'zinnen' and 'regels' are all in their
own column; A, B, C and D in row 1, row 2 idem dito.

In row 3 number 496 is in column A; 21 in B; 68 in C and the word Sole is in
D and the word Panelist is in column E. So in this example there are 5 rows
in total. The information in row 2-5 belong together.

I want to use a script on row 2-5 because the information in row 3-5 is
relevant for row 2.

I need to cut the information in the rows 2-5 and paste it behind the
information in row 2 in column E that is.

Who has an idea to do this?

Thanks, Jo
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
string matching adimar Microsoft Excel Worksheet Functions 2 14th Apr 2008 10:05 PM
String matching with wildcards Johnny Jörgensen Microsoft C# .NET 1 25th Sep 2007 12:00 PM
string matching Alex Lee Microsoft Excel Programming 8 5th Jun 2007 10:01 PM
String matching (Inteligent) anderskj1 Microsoft Dot NET 4 26th Sep 2006 11:01 AM
String matching (Inteligent) anderskj1 Microsoft C# .NET 4 26th Sep 2006 11:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:10 AM.