You are reading a single comment by @rhb and its replies. Click here to read the full conversation.
  • If workbook B is standalone and you cannot fuck with it, can you pull data into A using power pivot/ power query ?
    then you can reshape your data to your heart's content, using group by etc.

    Alternatively, fuck excel into the sun, link to the table your boss is creating in R and generate an html document that allows you to shine and get out of working there.

  • Alternatively, fuck excel into the sun, link to the table your boss is creating in R and generate an html document that allows you to shine and get out of working there.

    Sounds like a good plan!

About

Avatar for rhb @rhb started