Convert Data Vertical to Horizontal

**dextryn** · 02-19-2013, 06:14 PM

Hello, I have some data that is vertical
(ex.)

1 Disagree
1 Neutral
1 Agree
2 Poor
2 N/A
2 Excellent
3 Never
3 Sometimes
3 Always

And I'd like it to go

1 Disagree Neutral Agree
2 Poor N/A Excellent
3 Never Sometimes Always

Is this possible?

Thanks,

**dextryn** · 02-19-2013, 06:22 PM

I'm attaching the actual file to better show my issue.

**dextryn** · 02-19-2013, 07:27 PM

So, I think I already figured it out in case anyone was working on it.

I used a text editor to help me but in excel made an IF statement to put an x every time the number changed. =if(A2<A3,"x"," ")
Then I dumped it into a text editor, changed all the x' to returns (\r), replaced all the "returns" with tabs (\t), replaced the double tabs (\t\t) with single tabs (\t) and pasted it back into excel.

Not to say it couldn't have been done in excel, I'm sure it could have. I just found a way, so I figure I would close the question.