Hi All,
i have data that is in a list that the website creates. what i am trying to do it turn it into a grid so we can look at occurrences by account number... currently it comes up like this:
whichtype : Business
visatype : VisaApp
processingfees :
visaservice :
embassyservices :
country : India
procurement : 60.00
processingfee :
passportname1 :
passportname2 :
passportname4 :
passportcollect : Will Send In
nationality : India
collcontact :
collcompany :
colladd :
colladd2 :
colltown :
collpcode :
colltel :
dateofbirthday : 01
dateofbirthmonth : 01
dateofbirthyear : 2000
passportreturn :
delcontact :
delcompany :
deladd :
deladd2 :
deltown :
delpcode :
deltel :
account : 004368
username : VisaApp
costcenter :
ref2 :
ref4 :
ref3 :
ref5 :
ref6 :
costcenter :
booker_email :
client_email :
passportnum :
passportexpmonth :
passportexpyear :
addnotes :
conttel :
accadd :
destaccadd :
duebackbyd :
duebackbym :
duebackbyy :
traveldated :
traveldatem :
traveldatey :
passrepchg : 0.00
sendappform :
sendbusiness :
sendinvitation :
sendinviterequest :
sendlink :
visanumber : 4368000519
docnum : ZE259256
consultantname :
requirements : Valid passport for six months upon exit<br>Two clear pages in passport<br>Two recent photographs, 50x50mm in size<br>One application form, filled out online<br>Original UK company letter (refer below)<br>Invitation letter from company in India (refer below)<br>Proof of two years residency in the UK (refer below)<br>Non-UK resident form, if applicable (refer below)<br>Vaccination certificate, if applicable (refer below)<br>Declaration form (refer below)<br>Signed authorisation letter (refer below)<br>
whichtype : Business
visatype : VisaApp
processingfees :
visaservice :
embassyservices :
country : United Arab Emirates
procurement : 30.00
processingfee :
passportname1 :
passportname2 :
passportname4 :
passportcollect : Will Send In
nationality : United Kingdom
collcontact :
collcompany :
colladd :
colladd2 :
colltown :
collpcode :
colltel :
dateofbirthday : 01
dateofbirthmonth : 01
dateofbirthyear : 2000
passportreturn :
delcontact :
delcompany :
deladd :
deladd2 :
deltown :
delpcode :
deltel :
account : 004368
username : VisaApp
costcenter :
ref2 :
ref4 :
ref3 :
ref5 :
ref6 :
costcenter :
booker_email :
client_email :
passportnum :
passportexpmonth :
passportexpyear :
addnotes :
conttel :
accadd :
destaccadd :
duebackbyd :
duebackbym :
duebackbyy :
traveldated :
traveldatem :
traveldatey :
passrepchg : 0.00
sendappform :
sendbusiness :
sendinvitation :
sendinviterequest :
sendlink :
visanumber : 4368000520
docnum : ZE259292
consultantname :
requirements : Valid passport for six months upon exit<br>One clear page in passport<br>Onward/return travel tickets<br>Proof of sufficient funds <br>
whichtype : Business
visatype : VisaApp
processingfees :
visaservice :
embassyservices :
country : United Arab Emirates
procurement : 30.00
processingfee :
passportname1 :
passportname2 :
passportname4 :
passportcollect : Will Send In
nationality : Australia
collcontact :
collcompany :
colladd :
colladd2 :
colltown :
collpcode :
colltel :
dateofbirthday : 01
dateofbirthmonth : 01
dateofbirthyear : 2000
passportreturn :
delcontact :
delcompany :
deladd :
deladd2 :
deltown :
delpcode :
deltel :
account : 004368
username : VisaApp
costcenter :
ref2 :
ref4 :
ref3 :
ref5 :
ref6 :
costcenter :
booker_email :
client_email :
passportnum :
passportexpmonth :
passportexpyear :
addnotes :
conttel :
accadd :
destaccadd :
duebackbyd :
duebackbym :
duebackbyy :
traveldated :
traveldatem :
traveldatey :
passrepchg : 0.00
sendappform :
sendbusiness :
sendinvitation :
sendinviterequest :
sendlink :
visanumber : 4368000521
docnum : ZE259293
consultantname :
requirements : Valid passport for six months upon exit<br>One clear page in passport<br>Onward/return travel tickets<br>Proof of sufficient funds <br>
whichtype : Business
visatype : VisaApp
processingfees :
visaservice :
Select all Open in new window
what i need to do is turn it around so that the column headings are the fields. i.e "country" becomes a heading....
can anyone point me to the easiest route to do this
thanks,