Reorganizing data

Giganews Newsgroups
Subject: Reorganizing data
Posted by:  Taylor
Date: Tue, 3 Mar 2009

I'm trying to reorganize my data and I cannot find an easy way to do so.  I
need to repeat this task daily, so I'd prefer some type of automation instead
of the copy & paste method.  Here's the format of my data:

1 2 3 4 1 2 3 4
a b c d A B C D
e f g h E F G H

And here is the format I need it in:

a A
b B
c C
d D

Note: the lower case and capitalized letters represent completely different
values.  The capitalized letters are the counts of the lower case items.