Avatar of Arran Pumphrey
Arran Pumphrey
 asked on

Excel - Help converting or pulling data from a list to show in a grid

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 : 

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,
Microsoft ExcelVisual Basic Classic

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Arran Pumphrey

ASKER
worked a treat!!! thank you so much :)
Subodh Tiwari (Neeraj)

You're welcome. Glad to help. :)
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23