Forum Discussion
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, ...
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
I used PowerQuery to add numbering next to all rows which belong to a single reference and then fed that query result to a pivottable, see attached.
