Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/ SQL Statement
This may be simple and I just can't see it, but, here goes.
I will simplify this as much as possible. Table name: TABLE ITEM LOCATION QTY ABC 100 20 ABC 102 10 ABC 100 15 ABC 101 30 ABC 102 12 I know how to SUM and GROUP BY which will give me 3 rows (one for each location). But is there a statement that will return 1 row like this: ITEM LOCATIION 100 QTY LOCATION 101 QTY LOCATION 102 QTY ABC 35 30 22 Any help is much appreciated. DG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |