Forum Discussion
Cleaning data to import and transposing
- 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.
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.