Databases
StackOverflow2013
Postsdbo
POEXCEL Copy & Concatenate from one document to another
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEXCEL Copy & Concatenate from one document to another
    primarykey
    data
    text
    <p>I am having trouble figuring out how to reformat an exel sheet into 4 different sheets. As of now, I have to documents, one with data and one that needs the others' data reformatted.</p> <p>Here is the background:</p> <ol> <li>The first document has a 48 rows <em>(groups of 4)</em> for each (12)month of the year</li> <li>The according columns are from the years 2012-1950</li> <li><em>ex.--></em> First row is JANUARY with precipitation values for years 2012, then 2011, 2010, etc.</li> <li><em>ex.--></em> Second row is JANUARY with maxTemp values for the same years</li> <li>The third row is the same with minTemp and the fourth avgTemp; then these 4 are repeated 12 times</li> <li>I need to copy &amp; concatenate all of the months for one data type</li> <li>(in reverse order so that the data is instead from Jan1950-Jan2012)</li> <li>And paste it into a new row in 1 of 4 excel docs (one for each data type)</li> <li>So that one final row will contain <em>ex precipitation</em> Jan1950, Feb1950, March1950 ... Nov2012, Dec2012</li> <li>This way, one row will have 12(months)*62(years) IN ORDER from Jan1950 to Dec 2012</li> <li>Basically there will be 4 excel documents each with one really long row</li> </ol> <hr> <p>Here are my thoughts</p> <p>(Unless there is a better way) I was wondering if there is a macro (or a formula) that will:</p> <ol> <li>Take part of a row in reverse order (ie. Z3-C3) <em>corresponding to Precip of Jan1950-Jan2012</em></li> <li>Copy it and concatenate it with...</li> <li>The same part of another row in reverse order (ie. Z7-C7) <em>corresponding to Precip of Feb1950-Feb2012</em></li> <li>Another row in reverse order (ie. Z12-C12) <em>corresponding to Precip of Mar1950-Mar2012</em></li> <li>Repeat for all 12 months</li> <li>paste them into the precipitation excel document</li> <li>This needs to be done for all four data types (ie. Z4-C4 is minTemp Jan 1950-2012; Z8-C8 Feb; etc.)</li> </ol> <p><em>which once again yields, one row with data from Jan1950-Dec2012 for just that data type</em></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser1574832
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload