Page 1 of 1
| EXCEL query 31/07/2010 at 15:17 #1538 | |
Peter Bennet
5360 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
5360 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
1834 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
5360 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
1098 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
1834 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 |