From rows to columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1667455%22%20slang%3D%22fr-FR%22%3EFrom%20rows%20to%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1667455%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20a%20PDF%20database%20of%20contacts.%20When%20I%20copy%20and%20paste%20it%20in%20Excel%2C%20it%20all%20comes%20in%20one%20long%20column.%3C%2FP%3E%3CP%3EHowever%20this%20includes%20in%20the%20actual%20database%205%20columns%3A%20NAME%20FIRSTNAME%20MEDIANAME%20TYPE%20MAIL.%3C%2FP%3E%3CP%3EI%20use%20the%20function%20Transpose%20but%20this%20is%20very%20long.%3C%2FP%3E%3CP%3EWould%20you%20have%20a%20solution%20to%20rotate%20the%20cells%20per%20blocks%20of%20five%20cells%20to%20get%20my%20current%20database%20into%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise.%3C%2FP%3E%3CP%3EAlexander%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1667455%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1667572%22%20slang%3D%22en-US%22%3ERe%3A%20From%20rows%20to%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1667572%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F793860%22%20target%3D%22_blank%22%3E%40Azra_boost%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20copy%20and%20pasting%20the%20data%20into%20Excel%20you%20can%20use%20the%20Excel%20New%20PDF%20connector%20to%20connect%20you%20DATA%20and%20grab%20the%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EBelow%20Blog%20link%20might%20be%20helpful%20for%20you%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelexciting.com%2Fget-data-from-pdf-in-excel-with-power-query-pdf-connector%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelexciting.com%2Fget-data-from-pdf-in-excel-with-power-query-pdf-connector%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20that%20this%20is%20available%20only%20for%20(Office-365)%20users%20only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I have a PDF database of contacts. When I copy and paste it in Excel, it all comes in one long column.

However this includes in the actual database 5 columns : NAME FIRSTNAME MEDIANAME TYPE MAIL.

I use the function Transpose but this is very long.

Would you have a solution to rotate the cells per blocks of five cells to get my actual database into Excel?

 

Please advise.

Alexandre

1 Reply
Highlighted

Hi @Azra_boost 

 

Instead of copy and pasting the data into Excel you can use the Excel New PDF connector to connect you DATA and grab the information.

 

Below Blog link might be helpful for you 

https://excelexciting.com/get-data-from-pdf-in-excel-with-power-query-pdf-connector/

 

Note that this is available only for (Office-365) users only.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more