Results 1 to 6 of 6

Output from stats software in awkward wide format

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2022
    Location
    Ireland
    MS-Off Ver
    365
    Posts
    3

    Output from stats software in awkward wide format

    Hi,

    I use stata for my analysis and use the outreg2 add-on for converting my results to a format I can easily copy and paste into my word doc tables. This is fine for multivariate analysis but I'm creating large univariate tables and the program adds each new univariate result into a new column rather than immediately below the last column. Is there a quick way for me to move all the results into the first four columns? I don't need the #observations in the bottom row, just the coefficient and the confidence intervals.

    I would just go the long way and copy and paste each item but I have many tables like this and 95 rows in each so was hoping for a quick fix I can apply to all.

    Thanks in advance,

    Laura
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reshaping data (wide format to long format)
    By souryadas in forum Excel General
    Replies: 2
    Last Post: 11-15-2019, 04:59 AM
  2. Worksheet Wide Conditional Format
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2018, 10:26 AM
  3. [SOLVED] about restructure repeated measure data into long format from wide format
    By sohel_for in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-18-2015, 01:10 AM
  4. [SOLVED] Flattening A File - Awkward Data Output
    By vichisov in forum Excel General
    Replies: 6
    Last Post: 01-22-2015, 02:45 PM
  5. Rearranging data to wide format
    By erikabee in forum Excel General
    Replies: 5
    Last Post: 10-21-2014, 07:47 PM
  6. [SOLVED] Formula to convert awkward date format
    By dchubbock in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 11-27-2013, 02:02 PM
  7. transforming a long dataset into a wide format
    By dmunte in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 11:42 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1