change table values -macro, query, script

S

sm1

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
 
M

macropod

Hi sm1,

Are the data for each row all in once cell, or are there different columns in use?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

flip a table format 3
flip a sheet format 2
Some controls are locking when the form is opened 0
Insert Query output into a table 5
SQL query to select rows with highest vales 2
Two query logistic error problem. 0
Most Efficient Count? 7
Need enhanced table to text conversion 7

Top