Forum Discussion

Janet1890's avatar
Janet1890
Copper Contributor
Oct 26, 2021

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...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 26, 2021

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).

Janet1890's avatar
Janet1890
Copper Contributor
Oct 26, 2021

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.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 26, 2021

    Janet1890 Right now I'm unable to respond. Perhaps I'll be back tomorrow morning (my time) CET.

    • Janet1890's avatar
      Janet1890
      Copper Contributor
      Nov 01, 2021

      Riny_van_Eekelen  - GM - i never received a response on how to do this.  pls advise and thank you.

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Nov 01, 2021

        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?

Resources