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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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

E
  • Question
Report that multiplies tables ('tree tables')
Replies
1
Views
92
Cubist
Cubist
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
715
RoryA
RoryA
D
  • Question
I Can Only Group Dates by Selecting all Cells, not Single ones. Dialogue Box Won't Pop Up
Replies
1
Views
603
arthurbr
arthurbr
E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
1K
jkpieterse
jkpieterse
R
  • Solved
Plotting multiple data sets by year in Excel
Replies
7
Views
520
reporting_95
R

Forum statistics

Threads
1,216,018
Messages
6,128,305
Members
449,439
Latest member
laurenwydo

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