By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

Formating Columns

P: n/a
Don
I have a database that is tracking dimensional data. In order to do some
further analysis of this data I use a program called Mintab. So I'm
entering the data into Access, querying the data using Access, then
exporting the data to Excel, and finally copying and pasting into Mintab. A
long way it seems but really not that much at all, or so I think.
With that said here's my question/problem.
The query has many dimensional entries. An example would be;
Part # 1
Hole Size 1 Hole Size 2 Hole Size 3
2.000 2.001 2.004
Part # 2
Hole Size 1 Hole Size 2 Hole Size 3
2.001 1.999 2.002
Part # 3
Hole Size 1 Hole Size 2 Hole Size 3
2.002 2.001 2.003
etc.
When this data is in Access and is exported into an Excel format it read
across, from left to right (landscape if you will).
This is where I'm looking for help. Is there a way to have Access or Excel
auto format all of this data changing it from left to right and make it read
top to bottom? Right now I copy and paste (using paste special/transpose in
Excel). As this amount of information increases the task of formatting the
columns as I'm doing now will be a huge task.
Is there a way to do this that I'm missing?
If more information is needed just ask.
Thanks for your help,
Jun 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Don" <vz******@verizon.net> wrote in
news:l0fgg.2845$td6.2786@trnddc02:
I have a database that is tracking dimensional data. In order
to do some further analysis of this data I use a program
called Mintab. So I'm entering the data into Access, querying
the data using Access, then exporting the data to Excel, and
finally copying and pasting into Mintab. A long way it seems
but really not that much at all, or so I think. With that said
here's my question/problem.
The query has many dimensional entries. An example would be;
Part # 1
Hole Size 1 Hole Size 2 Hole Size 3
2.000 2.001 2.004
Part # 2
Hole Size 1 Hole Size 2 Hole Size 3
2.001 1.999 2.002
Part # 3
Hole Size 1 Hole Size 2 Hole Size 3
2.002 2.001 2.003
etc.
When this data is in Access and is exported into an Excel
format it read across, from left to right (landscape if you
will). This is where I'm looking for help. Is there a way to
have Access or Excel auto format all of this data changing it
from left to right and make it read top to bottom? Right now
I copy and paste (using paste special/transpose in Excel). As
this amount of information increases the task of formatting
the columns as I'm doing now will be a huge task.
Is there a way to do this that I'm missing?
If more information is needed just ask.
Thanks for your help,

Not sure how your Minitab experiment is configured, so you could
be asking for

Part # 1
Hole Size 1
2.000
Hole Size 2
2.001
Hole Size 3
2.004
Part # 2
Hole Size 1
2.001

OR
Part # 1 Hole Size 1 2.000
Part # 1 Hole Size 2 2.001
Part # 1 Hole Size 3 2.004
Part # 2 Hole Size 1 2.001

OR
2.000
2.001
2.004
2.001

I've seen all three formats, so cannot immediately offer advice.
Anyways, you should be able to build a query to give any of the
formats, or a report that you can export to Excel, or even
directly into Minitab.

--
Bob Quintal

PA is y I've altered my email address.
Jun 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.