On 14/07/2014 00:26, Johan Snyder wrote:
I have a lot of data in Column A.
They are in groups of 5 that must go together into 1 row.

This is how it looks now:
GUID
Player
Address
Type
Reason

I want it all arraged like this:

Column A all Guid's
Column B all Players
Column C all Address
Column D all Type
Column E all Reason

So that the first 5 rows in Column A are all moved to the 1st row and spread over 5 Columns

=TRANSPOSE(Sheet1!A1..Ennn) entered as an array formula with
Ctrl-Shift-Enter in Sheet2 columns A:E

You will need to put it on another page if you want the new version to
start in A1. Might want to hide the #N/A as well.

Please I'm totally at a lost and spend hours doing it manually.


--
Regards,
Martin Brown