I have a range of information on a spreadsheet as follows:
A B
1 Name: Tom Smith
Job Title: Sales
Organisation: Made up
Telephone: 1111 111 111
Email:
[email protected]
Subject:
Not much
I have another 300+ entries of data (of 8 rows exactly as above) totalling
2629 rows. the example above is how it appears on my spreadsheet i.e.
headings and names in the same cell (Name: Tom Smith) and sometimes seperate
cells (Email: / [email protected])
I need to create 6 columns for Name/Job
title/Organisation/Telephone/Email/Subject and then move the data into the
relevant columns. Any suggestions would be very helpful. I have tried using a
macro on one entry but am stuck as to how to apply it to repeat over a range
of data
Bookmarks