Creating 1 row from 12 rows of data

[bydganwil]

Hi there,

I have data in the following format:

TARGET QUESTION1 QUESTION2 QUESTION3 QUESTION4
MY TARGET YES
MY TARGET NO
MY TARGET N/A
MY TARGET YES

How can I reformat so that it looks like:

TARGET QUESTION1 QUESTION2 QUESTION3 QUESTION4
MY TARGET YES NO N/A YES

I have 145 different targets within the spreadsheet in the same format.

Many thanks

Rob

 

[Special-K99]

Youlll need to post more data.
Do all the Targets have 4 answers? That makes a difference.

 

[nuked]

Are there 4 rows for every target?