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
|