Search for content in message boards

Formatting charts, and exporting reports to Excel

Replies: 10

Re: Formatting charts, and exporting reports to Excel

Posted: 1353451446000
Classification: Query
Edited: 1353451775000
That's strange. I can only think that you are not following my instructions or I have left something out of my instructions?? Can anyone see a flaw in my instructions?

This is a small example of what I get. Due to the limitations of pasting a real row and column presentation into these message boards, the column are mashed together; but I think you can still see the idea.

Name Birth Date Birth Place

Arlie May Hallock 12 Jul 1886 Niles, Berrien, Michigan
Esther (____) 1835 Indiana
Hattie B Hallock 21 Mar 1883 Niles, Berrien, Michigan
Hazel E Hallock 05 Sep 1888 Buchanan, Berrien, Michigan, USA
Mary Main 1870 Michigan
Milly J. Main 1865 Indiana
Orin Main 1821 Ohio
Selfade Auchmoody Feb 1844 New York
Viola Caroline Main Mar 1861 Indiana
Wellington L Hallock 1854 Manchester, Ontario, New York, USA
______________

You will have to use Excel's text to columns command to split the name field into first, middle last columns and the place field into its components. That is why the report below is sorted by first name. I haven't split the name into first and last columns. BTW, that procedure has problems because a person with no middle name will have the last name in the 2nd column; if one middle name, it will split into the last name being third column, etc.
SubjectAuthorDate Posted
Mavis_OConnor 1353430601000 
silverfox3280 1353434253000 
Mavis_OConnor 1353438459000 
silverfox3280 1353451446000 
Mavis_OConnor 1353452405000 
silverfox3280 1353464818000 
Mavis_OConnor 1353473900000 
Mavis_OConnor 1353474903000 
silverfox3280 1353508757000 
Mavis_OConnor 1353528942000 
per page

Find a board about a specific topic