Before doing the exercise I thought that going sales and reviews sheets in excel would be more appropriate, as excel is better than tableu for data processing. However, I had certain difficulties while doing it. Could you give quick tip on how to combine those two spreadsheets into one?

Hi Emin, thanks for reaching out! To combine the two tables you need to join the two tables together. You could do that with the help of Tableau, Power Bi, or with SQL, for example. If you'd like to use Excel, you could try the merge option it provides. You can check out more on the topic from the following link: https://www.ablebits.com/office-addins-blog/2018/10/31/excel-merge-tables-matching-columns/ Hope this helps! Best, 365 Eli

back

Follow this topic

Emin Mammadzada

Last answered:

December 01, 2020

Posted on:

August 03, 2020

Joins in the exercise

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Posted on:

December 01, 2020

Submit an answer

Content