change table values -macro, query, script

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "sm1" <sm1@xxxxxxx>
Date: Fri, 8 Aug 2008 17:30:22 -0700

Hi,

I am looking for a solution where I could change the table in a different format. Any office product solution, Excel or Access or any other tool could be used where the process can be automated (macro, SQL query, etc)

I have this table:
T1 App1, App2, App3
T2 App4, App5
T3 App6, App7, App8

I want to create this table of the previous table:
App1 T1
App2 T1
App3 T1
App4 T2
App5 T2
App6 T3
App7 T3
App8 T3

Thank you for any help

.

Follow-Ups:
- Re: change table values -macro, query, script
  - From: macropod

Prev by Date: Re: center object in an other application?
Next by Date: Re: Specialized Viewer - Its a challenge for me, how about you? Help Needed
Previous by thread: How do I make a double horizonal line?
Next by thread: Re: change table values -macro, query, script
Index(es):
- Date
- Thread

Relevant Pages

flip a sheet format
... format. ... Any office product solution, Excel or Access or any other tool could ... be used where the process can be automated (macro, SQL query, etc) ...
(microsoft.public.excel)
Re: Formatting Dates
... We run an SQL query at work and the ... but they refuse to change. ... We tried the normal date format, no good, then we ... After you do this, Excel ...
(microsoft.public.excel.misc)