I have a long list of data in one column, without headers but with addresses and company names which has downloaded from a pdf.
However, the data is not in regular numbers of rows, ie, the first section is 12 rows, then the next is 15, etc, because it may have an extra email address in there or something. Is there a way to move these into a useable database? The last row always starts with the word "activity", although the length varies.
Many thanks for any advice.
P
plumfin,
Can we see the workbook containing the downloaded data from the pdf?
To attach the workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Hi Stan, sorry for the delay. Data attached.
Help
Good day
I hope someone can help me.
The problem I have is in excel lets say in sheet1 cell a1 is a description a2 a price a3 QTY and a4 text
and sheet 1 a1 description cell a2 price cell a3 QTY
What i want to do in when a person clicks to the text in cell a4 in must copy the info from sheet1 a1 to sheet2 a1and sheet1 a2 to sheet2 a2 and sheet1 a3 to sheet2 a3 but it must only do in if the cells on sheet 2 are empty if the cells in sheet 2 is not empty
it must use the next row
if any body can help me please you would save me a world of head pain.
you can e-mail me at [email protected]
Kind regards
Ikenye
plumfin,
Detach/open workbook ReorgData - Convert pdf data to table - plumfin - EF760146 - SDG15.xlsm.
There seems to be a pattern to the groups of data (see Yellow alternating Green).
Are the headings/titles and their order, what you are looking for?
If not, then please change/move them around.
And, are all the titles accounted for?
Ikenye,
Welcome to the Excel Forum.
You should not start a new post within another persons post.
You should start your own new post.
Originally Posted by stanleydgromjr
Hi Stan, that is exactly what I am after, without the time of going through and highlighting each section. Is there anyway to get excel to split this into a database-type document, for easy mail merge?
Do mean the titles, that each section has each title? In that case, no - some of the entries are 10 rows, for example, some may have a little extra detail and may be 14. Sorry - if this is not possible, please don't spend your time on it! Many thanks though so far.
Kelly
plumfin,
What is the structure, with titles, for your database-type document?Is there anyway to get excel to split this into a database-type document, for easy mail merge?
Once we have the structure for your database-type document, do you want the data on another worksheet, say worksheet Results?
The data groups are only colored Yellow and Green as a reference to understanding your requirements.
Are the titles in range R1:O1 correct?
1. the right order
2. the correct number of titles
3. Do you need to add/subtract any titles?
Sorry Stan, I misunderstood. Yes, the data you have extracted to the rows is the right titles, none missing, all ok. A new worksheet called Results would be good, to keep the 2 separate. Do you need anything else from me on the structure? The test data looks spot on, thanks.
plumfin,
The more I work on your raw data, the more confusing I get.
There is no logic for how the raw data is presented, and what title fields the data goes in.
I have exceeded the normal amount of time I allocate for solving problems/requests from web sites like ExcelForum.com.
Please click on the New Post button, and just enter the word BUMP, then click on the Submit Reply button, and someone else will assist you.
Ok many thanks Stan, I appreciate the time and effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks