Closed Thread
Results 1 to 1 of 1

transforming a bad list into a table

  1. #1
    Registered User
    Join Date
    02-22-2018
    Location
    Brazil
    MS-Off Ver
    1801
    Posts
    41

    transforming a bad list into a table

    EDIT: please delete this thread. I decided to move the post to the macro section

    Hello everyone

    I have txt list I would like to transform in a table. Its contents are distributed like this

    1. Journal name

    Title*

    Authors*

    Author information*

    Abstract*

    DOI

    PMCID

    PMID

    2. Journal name...

    and so on. * means that this information has a varying number of lines, depending on the article.

    I would like to turn that list in a table, where each article characteristic as a column, and each article title as a row. I'm not sure, but I believe pivot table is what can solve it. Any ideas?

    An example of my list is attached.
    Attached Files Attached Files
    Last edited by Diogo2; 02-04-2020 at 10:04 AM. Reason: moved to macro

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-07-2018, 04:26 AM
  2. Transforming table forms. Pivor Tables does not work as expected.
    By nikola2004mkd in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-07-2017, 08:12 AM
  3. Transforming pivot table back to the source table
    By Frile in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2015, 02:34 AM
  4. Replies: 1
    Last Post: 11-12-2014, 11:54 PM
  5. [SOLVED] Transforming Table and appending to one cell... conditionally.
    By falkon007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2013, 08:32 PM
  6. Copy and paste dynamic ranges + transforming into a table
    By tigerallied in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2013, 01:26 PM

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