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