[SOLVED] Data manipulation
Is it possible to convert a table such as this:
to this:HTML Code:
Where all question 1 fields are put into a row, 2 in another row, etc (this may be more than 2 sets of questions), grouped by the name field.HTML Code:
I have had a look at Pivot tables but they dont seem to do what Im after.
Many thanks in advance.
Last edited by abis123; 08-05-2009 at 05:01 AM.
You can expand this technique to as many Qs as you wish.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much for your help! Works like a charm. Very very much appreciated.Originally Posted by JBeaucaire
Ric.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks