Hi all,

I'm hoping someone will have the answer to this question. I have a spreadsheet with over 8000 rows of data. One of the column headings is Unit and the other is Result. Obviously all the data runs vertically down the sheet. I need to take these columns and somehow move them into a new spreadsheet HORIZONTALLY in rows not columns...

Is there anyway of doing this???

example - Current view

Name Unit Result
Joe 1 Pass
Joe 2 Fail
Joe 3 Pass


I need it to look like this

Name Unit Result Unit Result Unit Result etc
Joe 1 Pass 2 Fail 3 Pass

Looking forward to hearing of any solutions to this problem~!

Thanks,
Jodie