PC Review


Reply
Thread Tools Rate Thread

ALIGNING TWO ARRAYS OF DATA VALUE

 
 
sunan
Guest
Posts: n/a
 
      20th Jun 2008
This si about comparing two sets of separate data into one aligned worksheet
as folows:
XXX 300
YYY 250
ZZZ 175
XXX 312
YYY 267
ZZZ 177
to be aligned:

XXX 300 312
YYY 250 267
ZZZ 175 177

Can we do it the simple way?
thanks,
sunan




--
sunan
 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      21st Jun 2008
Try Pivot Table.
No formulas needed.
http://www.savefile.com/files/1621696
 
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
RE: aligning data Shane Devenshire Microsoft Excel New Users 0 3rd Mar 2009 03:20 AM
aligning data jos.bogg@wheel.co.uk Microsoft Excel Programming 2 21st Sep 2006 05:17 PM
Aligning decimal numers to the centre of the cell and aligning dec =?Utf-8?B?UmFtZXNoIEJhYnU=?= Microsoft Excel Misc 1 1st Jul 2006 10:33 PM
Aligning rows of data from multiple data sets in columns e abor Microsoft Excel Discussion 1 29th Jun 2006 09:21 AM
Re: Re-aligning data Dave Peterson Microsoft Excel Misc 1 24th Aug 2003 10:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 AM.