Problem with Excel with Query

A

Ashish Kanoongo

I have a table with following information

Code - c(6)
Name - c(20)
txnCode1 - c(3)
txnCode1Value n(12,2)
txnCode2 - c(3)
txnCode2Value n(12,2)
txnCode3 - c(3)
txnCode3Value n(12,2)


In txncode1, txncode2, txncode 3 field, value can be placed in any of these 3 field i.e "aa" can be exist in any of one in every record. Now my problem how do I present under one column for exg. 'aa' column.

I want to export in excel in following format

Code Name Txncode1 txncode2 txncode3
-----------------------------------------------------------------------------------
 

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

Problem with Excel with Query 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Synchronization problems while moving folders to new email 1
Macro to delete row if cells greater than certain value 1
Index / Match Formula Problem 4
Compute Additional Hours Needed Using "if" or "lookup" 1
Running Excel Code from Access 9

Top