View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jesper Audi Jesper Audi is offline
external usenet poster
 
Posts: 21
Default Rows to columns in a table or pivot table

Lets say I have 2 business cards with tel nos, either main or direct

field order field Details
1 name Adrian Briggs
2 main tel +44 (0)161 927 8200
1 name Ajaz Chaudhri
3 direct tel +44 (0)161 927 8305

All I want is a speradsheets nthat puts the right info under the correct
column

1 2
3
name main tel direct tel
Adrian Briggs +44 (0)161 927 8200
Ajaz Chaudhri +44 (0)161 927
8305


Actually I have 22 fields, but each business card actually has different
fields which I have coded up 1-22.

If this is not clear, am I able to put in a screen shot??


Thanks

Jesper