Log In
Register
Home
New Member
March 25, 2022
Offline
I am new to thi so I apologize if I'm unclear. I have an Excel file hooked up to my Outlook and pulling in certain emails that I receive that have a table with data in the body of the email.
example of the body of the email looks like this
| Date | Name |
| 1/23/2022 | Mike Jones |
| 1/24/2022 | Steve Qual |
| 2/10/2022 | John Doe |
Currently in power query it looks like this in a single cell
Date Name
1/23/2022 Mike Jones
1/24/2022 Steve Qual
2/10/2022 John Doe
I already have columns for when the email was sent, the subjet but ideally i want to find a way to transform the spreadsheet so the headers for Date and Name will be its own column headers and the data will be fitted underneath in each row. Is this possible to do ?
I was able to create the columns and headers but cant figure out how to automatically pull the data under it and continue going forward. Unfortunately I cant attach a copy because its work related. Any help would be greatly appreciated
Trusted Members
February 13, 2021
Offline
Hi Aaron!
My recommendation would be to write a macro that will copy the data from your e-mail and paste it into your spreadsheet, that way the import is at least not all in one cell. Should come in with each line, at least, in the correct row. Then you can either clean up the data in the macro you're already writing or send it to PQ to split by delimiter and trim the data. Good luck!
1 Guest(s)
