Transpose??
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
|