import and transform kindle clippings into excel with power pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-2081747%22%20slang%3D%22en-US%22%3Eimport%20and%20transform%20kindle%20clippings%20into%20excel%20with%20power%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081747%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20monthly%20basis%20I%20import%20my%20clippings%20from%20the%20Kindle%20reader%20to%20Excel.%20They%20come%20out%20of%20the%20Kindle%20as%20a%20txt%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20collect%20and%20transform%20every%20month%20clippings%20through%20power%20pivot%20in%20order%20to%20save%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20have%20a%20look%20on%20the%20attached%20excel%20a%20see%20if%20it%20would%20be%20possible%20to%20transform%20data%20as%20it%20comes%20in%20Page%202%20to%20what%20I%20would%20like%20to%20order%20in%20page%201%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EKindle%20export%20also%20marks%20and%20this%20is%20a%20%E2%80%9C3%20file%20record%E2%80%9D%20while%20the%20interesting%20clippings%20are%20recorded%20in%20%E2%80%9C4%20file%20records%E2%80%9D.%3C%2FLI%3E%3CLI%3EI%20have%20enclosed%20the%20also%20de%20txt%20doc%20received%20from%20the%20Kindle%20but%20as%20a%20word%20version%2C%20(txt%20documents%20not%20allowed%20to%20be%20uploaded)%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20in%20advance%2C%20Juan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2081747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

hi,

 

On a monthly basis I import my clippings from the Kindle reader to Excel. They come out of the Kindle as a txt document.

 

I am trying collect and transform every month clippings through power pivot in order to save time.

 

Could someone have a look on the attached excel a see if it would be possible to transform data as it comes in Page 2 to what I would like to order in page 1?

 

Please note that :

 

  1. Kindle export also marks and this is a “3 file record” while the interesting clippings are recorded in “4 file records”.
  2. I have enclosed the also de txt doc received from the Kindle but as a word version, (txt documents not allowed to be uploaded)

 

Thank you very much in advance, Juan

0 Replies