Forum Discussion
functions and formulas
good morning, i have a data sheet, one column has the letters in there, however, there is a comma after each letter. the report that i received from the other team has all of the info, however, they have it on one line each. how or what function can i use to pull the info from the team that has them on one line, and make sure i capture all of the info onto my listing. i.e. my list has control number and then the next column has the letters, a,b,c. their report has the control number on one line, and then the next column has the letter a, next line on their report, same control number, but letter b. next i would need to know if all of the info that they received is on my listing so they have one more column that i would need to add to my report yes/no.
if someone knows how to do this, i would really appreciate any help. thank you.
7 Replies
Janet1890 It sounds like something that can be done with Power Query. Can you upload some example data with both listings (yours and the other team's).
Riny_van_Eekelen thank you for getting back to me. i have uploaded what the other team sent to me and what i have. so trying to figure out how to do it without doing this manually. lol 🙂 thank you.
Janet1890 Right now I'm unable to respond. Perhaps I'll be back tomorrow morning (my time) CET.
