Loading...

excel-macros@googlegroups.com

[Prev] Thread [Next]  |  [Prev] Date [Next]

$$Excel-Macros$$ Re: How to extract data from an array saggi Mon Jan 31 23:00:12 2011

Kindly use text to column Function for above result

Regards
Vijay

On Jan 31, 11:52 pm, jmccaski <[EMAIL PROTECTED]> wrote:
> I have an arry of over 21,000 rows with data in this format:
> VarName TimeString      VarValue
> Pos     27.01.2011 12:49:35     32
> Pres    27.01.2011 12:49:35     -2
> Setpt   27.01.2011 12:49:35     100
> Gain    27.01.2011 12:49:35     1
> Int     27.01.2011 12:49:35     10
> Pos     27.01.2011 12:49:36     32
> Pres    27.01.2011 12:49:36     -2
> Setpt   27.01.2011 12:49:36     100
> Pos     27.01.2011 12:49:37     32
> Pres    27.01.2011 12:49:37     9
> Setpt   27.01.2011 12:49:37     100
> Pos     27.01.2011 12:49:38     32
> Pres    27.01.2011 12:49:38     9
> Setpt   27.01.2011 12:49:38     100
> Pos     27.01.2011 12:49:39     32
> Pres    27.01.2011 12:49:39     24
> Setpt   27.01.2011 12:49:39     100
> Pos     27.01.2011 12:49:40     32
> Pres    27.01.2011 12:49:40     24
> Setpt   27.01.2011 12:49:40     100
> Gain    27.01.2011 12:49:40     1
> Int     27.01.2011 12:49:40     10
>
> I'm trying to get it into a format something like this in order to
> chart it:
> TimeString              Pos     Press   Setpt   Gain    Int
> 27.01.2011 12:49:35     32      -2      100     1       10
> 27.01.2011 12:49:36     32      -2      100
> 27.01.2011 12:49:37     32      9       100
> 27.01.2011 12:49:38     32      9       100
> 27.01.2011 12:49:39     32      24      100
> 27.01.2011 12:49:40     32      24      100     1       10
>
> Any help would be greatly appreciated.

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to [EMAIL PROTECTED]

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel