Pivot table like look but with text HELP!

A

adtranzit

New Member
Joined
Aug 9, 2005
Messages
9
HI need to connect to a ODBC source and create a pivot table like view of the data (i dont need the ability to change this view by the user - if that is a n issue!)

here is my data...
car1,workorder111,DATE2007
car2,workorder123,DATE2007
car2,workorder222,DATE2008


and what im want to achieve in column view

DATE2007 DATE2008
Car1 workorder111
Car2 workorder123 workorder222


Is this possible and if required which book would cover the area on ODBC and this kind of issue? Pivots are great but wont work with trying to give my customers a visual view with real text data -HELP
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
Hi,

Please use TRANSFORM in the SQL. As you have text in the data field, maybe use MAX for the aggregate data function. I'm sure I have previoslu posted on using TRANSFORM so a search of old posts might have some further relevant info. Regards, Fazza
Code: 
TRANSFORM MAX(MD.WorkOrder)
SELECT MD.Job
FROM MyData MD
GROUP BY MD.Job
PIVOT MD.Date
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
231
cooleomter
C
T
  • Question Question
help with data shared between tables
Replies
0
Views
208
The_Flapjack
T
trishcollins
  • Solved
Excel vba set bold specific text of string into the cell in Pivot table.
Replies
2
Views
465
trishcollins
trishcollins
N
  • Question Question
Pivot Table Issues After Applying Formats
Replies
0
Views
495
Nordicrx8
N
E
  • Question Question
Report that multiplies tables ('tree tables')
Replies
1
Views
238
Cubist
Cubist

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top