Forum Discussion
functions and formulas
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.
Riny_van_Eekelen - GM - i never received a response on how to do this. pls advise and thank you.
Janet1890 Sorry! It slipped my mind. There's no way to mark a post as unread or for follow-up.
I've pulled the information from the Other Team in the My Team file. It's easier to demonstrate that way.
Used PowerQuery to reshape the "My Team" data so that it will match the structure of the Other Team list. I found no matching control numbers between the two, so you would want to append the two to get a complete list. Is that what you had in mind?
Riny_van_Eekelen - that would be the only way that i can do that. do you think you might be able to write out step by step instruction for me? i.e. 1) pull rpt 2) separate your rpt to single columns doing this, 3) do power query doing this...something like that. it would help me. thanks,