Forum Discussion

SaraVG's avatar
SaraVG
Copper Contributor
Mar 03, 2020
Solved

Cleaning data to import and transposing

I need to download a long list of citations from an online library database. The data downloads only in plain text. It contains 11 pieces of information such as name, title of article, journal name, ...
  • ExcelExciting's avatar
    Mar 03, 2020

    Hi SaraVG 

     

    Solution for your query by using the Power Query, you must have Excel 2016 or above to run this query 

    1. I have created table just paste your data in the file 

    2. Go to Sheet2 right click & refresh details will get update 

     

    Note i have observed some paragraph "Hilary E. Jacobsen" has 12 line which will allocate into the next column, to adjust that you just need to manually adjust the records. Make sure to have 11 columns.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

    If you find the above solution resolved your query don't forget mark as Official Answer.

     

     

Resources