excel change 4 rows / 48 col to 48 rows / 4 col
- by GoodOlPete
Hi,
I've selected 4 database records of 48 fields into excel as below:
FirstName LastName Age Address1 .......................
Andy smith 23 53 high st
billy ball 43 23 the avenue
charles brown 76 rose cottage
dave green 43 station rd
I want to display them as
firstname andy billy charles dave
lastname smith ball brown green
age 23 43 76 43
address1..............................
Can anyone suggest how to do this?