Excellent video and super helpful! Simple, precise and easy to understand. Thank you Excel Master for your quick replies and help when I stumbled on solving my pivot table relationship error!
I know I’m not the only one who hates the music at the background. Why don’t you just talk through the tutorial instead?? Keep explaining the steps so we can understand better
Hover the second set of tables is not dynamic as you copied and then configurated as a table too. Means if your information in first set of pivot tables changes it won't update the last pivot table.
I have two unique columns i cant combine them. The message says 'Both selected columns contain dupkicate values. At least one of the coulmns selectes must contai unique values to ctreate a relationship between the tables'. Do you know why and how to fix it? the unique column is gorup numbers.😊
I've 2 tables that are fed from Salesforce - both are identical as I'm unable to extract more than 2000 columns from Salesforce. The overall data I need to extract is 2600 columns. I get the error message that both tables are similar, unable to proceed. Is there a work around to merge/connect both tables with similar date?
I have a sheet of data in multiple columns with staff name and working hours for Monday to Sunday, im unable to do pivot table Row (staff), Column(week) and Value(hours)
No video ... Just create a single "structured" table with a column for sales and a separate column for Purchase. Then just do a normal pivot table and use two value columns.
Excellent video and super helpful! Simple, precise and easy to understand. Thank you Excel Master for your quick replies and help when I stumbled on solving my pivot table relationship error!
Thank you for your lovely 😍 feedback.
I know I’m not the only one who hates the music at the background. Why don’t you just talk through the tutorial instead?? Keep explaining the steps so we can understand better
Hi. Thank you for your feedback. This is one of my old video. In my latest videos i have recorded my voice as well. You came check my videos
Hover the second set of tables is not dynamic as you copied and then configurated as a table too. Means if your information in first set of pivot tables changes it won't update the last pivot table.
Ok
This helps me very much. Thank you.
You're welcome!
I have two unique columns i cant combine them. The message says 'Both selected columns contain dupkicate values. At least one of the coulmns selectes must contai unique values to ctreate a relationship between the tables'. Do you know why and how to fix it? the unique column is gorup numbers.😊
Hi,
Will check and revert. Please share your excel file to myxlmaster@gmail.com
I've 2 tables that are fed from Salesforce - both are identical as I'm unable to extract more than 2000 columns from Salesforce. The overall data I need to extract is 2600 columns. I get the error message that both tables are similar, unable to proceed. Is there a work around to merge/connect both tables with similar date?
Hi, please mail to myxlmaster@gmail.com. will check and revert you
Did you just copy and paste the value from the pivot tables? It wont update when the source data updates
Yes. You can also refer the new video on merging tables
Exactly. This is completely pointless if you have to redo it every time the data changes.
Can you just directly work on pivot tables and get the calculated results?
For example percentage
Yes Sure... For your information i have already presented this in my previous videos. You can check that also.
@@MyExcelMaster I have two pivot tables and want to calculate percentage
Will check your video
I have a sheet of data in multiple columns with staff name and working hours for Monday to Sunday, im unable to do pivot table Row (staff), Column(week) and Value(hours)
Hi,
I will check and update you. Please share me the file to myxlmaster@gmail.com
AFTER COPY THE THE TABLE, HOW TO CREATE HEADERS BEFORE MERGING?
Hi, just rename it
Thanks bro this is help me
Thank you
If we add more data the formula is ok
Thank you
Let's say hypothetically, you had a branch with sales data but no purchase data, how would you get that to show up on your merged table?
Hi, merging is possible only when we have multiple tables
Thank you!!!
Thank you for your valuable feedback.
This method may have been popular 15 years ago ... The same thing you did can be done in 7 clicks today.
Thank you for your feedback
What method do u mean
@user-yq4xx8cz1e Do you know a video where they explain the 7 clicks method, I cannot find a video that explains this in a quickly mannner
No video ... Just create a single "structured" table with a column for sales and a separate column for Purchase. Then just do a normal pivot table and use two value columns.
Without explained woww
Thank you for your lovely feedback
You are a funny creature
Thank you for your valuable feedback
how to delete?
Hi. Can you please elaborate
Thanksful,
Welcome
this is not efficient way for appending tables(
Exactly. He is not very skilled at excel .
Sorry... Please correct me if anything is wrong
Sorry. Please correct me if anything is wrong
Ftyfcnqqsjiky11 é fundamental
thanks yrr
Welcome 😊
please remove music. not able to concentrate.
Hi,
Regret for the inconvenience caused. Noted your feedback and changed it. Thank you for your valuable feedback.
sorry to tell you about the
annoying background music
Hi,
Regret for the inconvenience caused. Noted your feedback and changed it. Thank you for your valuable feedback.
Very boring
Sorry to hear this