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



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