Page 1 of 1
EXCEL query 31/07/2010 at 15:17 #1538 | |
Peter Bennet
![]() 5377 posts |
I have a column of data A2, A3, A4 etc and I want to create a grid table with the A2 copied to B1, A3 copied C1 etc Is there a quick way to do this, tried what I see as the obvious to no avail and not found anything in the 'help' so far. Peter I identify as half man half biscuit - crumbs! Log in to reply |
EXCEL query 31/07/2010 at 15:17 #10360 | |
Peter Bennet
![]() 5377 posts |
I have a column of data A2, A3, A4 etc and I want to create a grid table with the A2 copied to B1, A3 copied C1 etc Is there a quick way to do this, tried what I see as the obvious to no avail and not found anything in the 'help' so far. Peter I identify as half man half biscuit - crumbs! Log in to reply |
EXCEL query 31/07/2010 at 16:16 #10365 | |
AndyG
![]() 1842 posts |
try copy /paste special, think there's an option to transpose/rotate
I can only help one person a day. Today's not your day. Tomorrow doesn't look too good either. Log in to reply |
EXCEL query 31/07/2010 at 16:19 #10366 | |
Peter Bennet
![]() 5377 posts |
Brilliant- thanks. Peter I identify as half man half biscuit - crumbs! Log in to reply |
EXCEL query 31/07/2010 at 16:19 #10367 | |
Meld
![]() 1108 posts |
Cheers Andy it is transpose - just tried it out works a treat ![]() Passed the age to be doing 'Spoon Feeding' !!! Log in to reply |
EXCEL query 31/07/2010 at 16:34 #10368 | |
AndyG
![]() 1842 posts |
No problem, only took me about 4 years to find it.
I can only help one person a day. Today's not your day. Tomorrow doesn't look too good either. Log in to reply |