A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Extracting data from one row across multiple columns to produce a list



 
 
Thread Tools Display Modes
  #1  
Old September 7th, 2004, 09:32 AM
external usenet poster
 
Posts: n/a
Default Extracting data from one row across multiple columns to produce a list

I've got a worksheet containing the data extracted from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on a
separate row. I need to find a way of looking up all the
answers from one particular question (i.e. the data from
the same row of multiple columns) and then extracting
these in the form of a list without
duplicates. Can anyone help?

  #2  
Old September 7th, 2004, 10:38 AM
Paul Lautman
external usenet poster
 
Posts: n/a
Default

Are you saying that you want to transpose the results from columns to rows?

If so then use Copy and Paste Transpose, or use the TRANSPOSE function.

wrote in message
...
I've got a worksheet containing the data extracted from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on a
separate row. I need to find a way of looking up all the
answers from one particular question (i.e. the data from
the same row of multiple columns) and then extracting
these in the form of a list without
duplicates. Can anyone help?



  #3  
Old September 7th, 2004, 01:27 PM
external usenet poster
 
Posts: n/a
Default

Transpose doens't work. I've got the answers to one
particular question all in the same row but each answer
is in a separate column, I want to extract all of the
answers and put them into one column without duplicates.

-----Original Message-----
Are you saying that you want to transpose the results

from columns to rows?

If so then use Copy and Paste Transpose, or use the

TRANSPOSE function.

wrote in message
...
I've got a worksheet containing the data extracted from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on a
separate row. I need to find a way of looking up all

the
answers from one particular question (i.e. the data

from
the same row of multiple columns) and then extracting
these in the form of a list without
duplicates. Can anyone help?



.

  #4  
Old September 7th, 2004, 03:02 PM
Paul Lautman
external usenet poster
 
Posts: n/a
Default

I'm afradi that you are still not being very clear.

What is it about transpose that doesn't work?
Where are the duplicates that you wish to remove?

wrote in message
...
Transpose doens't work. I've got the answers to one
particular question all in the same row but each answer
is in a separate column, I want to extract all of the
answers and put them into one column without duplicates.

-----Original Message-----
Are you saying that you want to transpose the results

from columns to rows?

If so then use Copy and Paste Transpose, or use the

TRANSPOSE function.

wrote in message
...
I've got a worksheet containing the data extracted from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on a
separate row. I need to find a way of looking up all

the
answers from one particular question (i.e. the data

from
the same row of multiple columns) and then extracting
these in the form of a list without
duplicates. Can anyone help?



.



  #5  
Old September 8th, 2004, 10:03 AM
external usenet poster
 
Posts: n/a
Default

Cut and Paste Transpose works, but I cant use this as I
need the extracted data to update as and when I add
further sets of questionnaire answers to the original
data. I tried to use the Transpose function in the cell
I want the list to appear and then selected the row of
data I want to copy but it comes back as #VALUE!

A small example of what I'm working with:

A B C D
OH Mgr Site Mgr OH Mgr HR Supervisor

The entry in each column represents an individuals answer
for the same question, they are all on the same row just
in different columns. I want to look up all the answers
for that particular question, remove the duplicates and
then put them in a list in one cell on another worksheet.
By removing the duplicates I mean I don't want the list
to just be a copy of the whole row, for example in the
above example I want the list to read as:

OH Mgr, Site Mgr, HR Supervisor

Not: OH Mgr, Site Mgr, OH Mgr, HR Supervisor


-----Original Message-----
I'm afradi that you are still not being very clear.

What is it about transpose that doesn't work?
Where are the duplicates that you wish to remove?

wrote in message
...
Transpose doens't work. I've got the answers to one
particular question all in the same row but each answer
is in a separate column, I want to extract all of the
answers and put them into one column without

duplicates.

-----Original Message-----
Are you saying that you want to transpose the results

from columns to rows?

If so then use Copy and Paste Transpose, or use the

TRANSPOSE function.

wrote in message
...
I've got a worksheet containing the data extracted

from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on

a
separate row. I need to find a way of looking up

all
the
answers from one particular question (i.e. the data

from
the same row of multiple columns) and then

extracting
these in the form of a list without
duplicates. Can anyone help?



.



.

  #6  
Old September 8th, 2004, 12:09 PM
Paul Lautman
external usenet poster
 
Posts: n/a
Default

Well, I guess we're getting there slowly!

You would do better to give a fuller explanation of the circumstances up
front.

Now, are you saying that columns A & D always contain the same data, or is
this just the case for a particular row?

The TRANSPOSE function works fine for me, so I can't see why you would have
an error. Maybe you could post an example somewhere on a web site.

If you are after a function that will show you what you seem to be asking
for, then I think you will be out of luck.

You will have to process the data somehow maybe using Filters and/or a
macro.

This MAY require use of pasting Transpose (if filters are to be used) or may
not (if a macro will examine all the entries).

wrote in message
...
Cut and Paste Transpose works, but I cant use this as I
need the extracted data to update as and when I add
further sets of questionnaire answers to the original
data. I tried to use the Transpose function in the cell
I want the list to appear and then selected the row of
data I want to copy but it comes back as #VALUE!

A small example of what I'm working with:

A B C D
OH Mgr Site Mgr OH Mgr HR Supervisor

The entry in each column represents an individuals answer
for the same question, they are all on the same row just
in different columns. I want to look up all the answers
for that particular question, remove the duplicates and
then put them in a list in one cell on another worksheet.
By removing the duplicates I mean I don't want the list
to just be a copy of the whole row, for example in the
above example I want the list to read as:

OH Mgr, Site Mgr, HR Supervisor

Not: OH Mgr, Site Mgr, OH Mgr, HR Supervisor


-----Original Message-----
I'm afradi that you are still not being very clear.

What is it about transpose that doesn't work?
Where are the duplicates that you wish to remove?

wrote in message
...
Transpose doens't work. I've got the answers to one
particular question all in the same row but each answer
is in a separate column, I want to extract all of the
answers and put them into one column without

duplicates.

-----Original Message-----
Are you saying that you want to transpose the results
from columns to rows?

If so then use Copy and Paste Transpose, or use the
TRANSPOSE function.

wrote in message
...
I've got a worksheet containing the data extracted

from
an electronic questionnaire, each set of answers are
contained in one column with each quesion answer on

a
separate row. I need to find a way of looking up

all
the
answers from one particular question (i.e. the data
from
the same row of multiple columns) and then

extracting
these in the form of a list without
duplicates. Can anyone help?



.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging multiple columns of data into one column rhett miller Worksheet Functions 2 June 10th, 2004 09:43 PM
Mial merge data base problems Rachael Mailmerge 16 May 21st, 2004 06:22 PM
Exporting Data By List Samkat Worksheet Functions 0 November 25th, 2003 06:04 PM
Multiple Charts from single instance of data dvt Charts and Charting 1 September 21st, 2003 01:45 PM
How to compare Multiple Rows and Columns to get data Lee Li [MSFT] Setting up and Configuration 0 September 15th, 2003 09:09 AM


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.