Jump to content
Salesforce and other SMB Solutions are coming soon. ×

change data from columns to rows


osric
 Share

Recommended Posts

Hi guys,

I'm hoping someone can help please. I have a database detailing lung nodules seen on patient scans. we have 200 patients who may have anywhere between 1 and 20 nodules. each nodule has an individual ID and fields on size, location etc. the nodule data is stored in a table with one nodule per row. I would like to export the data into excel so that all the nodules for a single patient appear on a single row. Currently I only seem to be able to export the first nodule, or else all nodules subgrouped by patient but appearing as columns.

 

is there a way of exporting this data in the way I require?

thanks in advance!

Link to comment
Share on other sites

What you are suggesting has been called both a "pivot table" and/or "cross-tab" data view. AlHunter3 has some of the best experience of the active mentors here advising on posted questions (sorry if I missed someone).

 

Daniel Woods ("Weetbicks") has written a blog post here on his 2/21/11 post. And there is a commerical product named ccpivot that accomplishes what you are asking.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use