How to Unpivot Data in Excel using Pivot Table Method
How to Unpivot Data in Excel using Pivot Table Method
Excel Pivot Table Playlist Link- • Excel Pivot Tables
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#unpivotdata #pivottablemethoud#innozant #unpivotdatausingpivottable#pivottabletricks
Пікірлер: 67
Thank you so much sir
ThankxSir
Thank u
You are amazing Sir! . Thank you Sir . I will be looking for more seasons from your series. I have learnt very much about Pivot tables now.
@Innozant
3 жыл бұрын
Thanks Sandeep Ji❤️
@someonefrom2002
2 жыл бұрын
Sandeep ji, aaj kal aap kahi invisible se ho gye hai Kaha hai aap Hum aapko comments me dhundte hai
Superb
A lot of thanks sir g your great sir g 🥰
Superb se bhi upper👍
@Innozant
3 жыл бұрын
Thanks Sushma..Have a Nice Day Ahead
Thanks a ton sir 😊 dil se ❤
@Innozant
Жыл бұрын
Thanks Altaf
It's magic sir.. Unique video..
@Innozant
3 жыл бұрын
Thanks dear❤️
Great concept sir thank you so much...its a pleasure to me being the part of Innozant Family...👍👍👍
@Innozant
3 жыл бұрын
Thanks Rajiv Ranjan Ji..God bless you dear❤️❤️
Nice Sir Ji Aap ki every topic majedar HOTA hai 🙏🙏🙏
@Innozant
3 жыл бұрын
Thanks Manoj Ji aapke appreciation ke liye dear
Dear Sir Superb video for unpivot data. Your all videos are very useful and attractive as usual. An excel beginner can try different methods to solve one particular problem. Carry on Sir. Thanks & Regards Jayanta Bhattacharyya
@Innozant
3 жыл бұрын
Thanks Jayanta..Have a great day ahead
Bahut achi aaj ki series sir🙏🙏🙏
@Innozant
3 жыл бұрын
Thanks Durgesh Ji❤️❤️
जय गुरुदेव
@Innozant
3 жыл бұрын
Good evening Pradeep Ji❤️❤️
@pradeepjangid490
3 жыл бұрын
@@Innozant thanks sir
Work better work hard
@Innozant
3 жыл бұрын
❤️
Super 🔥🔥🔥
@Innozant
3 жыл бұрын
❤️❤️❤️
Super ♥️ Sir, Ye aaj ho Gaya shope kaa project, Sir Ek Request Hai Next Jo v project hoga oh Airport ya Railway Station Kaa hoga tho Accha hoga 🙏💞
@Innozant
3 жыл бұрын
Ok dear Noted..❤️❤️👍👍
Very great sir
@Innozant
3 жыл бұрын
❤️❤️❤️
Awesome sir 👍👍👍. good night sir 🙏🙏🙏
@Innozant
3 жыл бұрын
Thanks Satish Ji..Good Night ❤️❤️
Samaj me yaya magar kum lekin aapka samajne ka tarike bahot achha laga thank you so much sir
@Innozant
3 жыл бұрын
Oho..simple to hai Kishor...aap pehle data dekhiye Repirt Layouut.phir dekhiye Noalize form data ka..whi maine btane ki koshish ki hai pivot table ke through normalize data bnane ka..ek baar phirse dekhiye video aap aayega samajh dear
@kishorpanara4191
3 жыл бұрын
@@Innozant ok sir
Amazing Sir Ji
@Innozant
3 жыл бұрын
Thanks Gusain sahab
Notifications do not come whenever new videos come even after bell icon pressed.
Dear Sir, If In Time and Out Time in a table is in same column.. Need to take In Time and Out Time in same row... How to do so.
Sir, aap pivot table me reconciliation kaise smart way me bataye
Very useful Zara Hat Kay. Sir g
@Innozant
3 жыл бұрын
Thanks Khalid Ji❤️❤️
Please upload both Power Query & Power Pivot Series, i couldn't find these 2 in your playlist!!
@Innozant
2 жыл бұрын
Seprate playlist of power query and power pivot is available in our channel
@zzzzz644
2 жыл бұрын
@@Innozant Got it 👍👍 thanks
Sir ji pls start topic of VBA too
@Innozant
3 жыл бұрын
Krenge vba bhi start dear
Sir please share the link for Power Query tool, I was looking for PowerBi and Power Query in your videos but did not find.
@Innozant
3 жыл бұрын
Power query seprate playlist are there dear..power bi soon m going to start the series
Sir ji ! Any solution to keep the background colour constant in dashboard. Whenever I apply filters using slicers in the table and tables shrinks to show the filtered data. You will notice that it changes the background colour to white for the cells where pivot table had data earlier. I tried conditional formatting and looked multiple videos and articles. Ab ap he help kro
@Innozant
3 жыл бұрын
Povot table options ne jake preserve cell formatting check krna ek baar
@AyushDubey205
3 жыл бұрын
@@Innozant thanks for reply but tried that as well. Would you mind sharing your email address or something so that I can share the details with you. If possible 😊
👍
@Innozant
3 жыл бұрын
Thanks dear❤️❤️
Sir t formula video basic to advanced level
@Innozant
3 жыл бұрын
Basic to advanced ke playlist insequennce hajj dekhiye Ur seekhiye dear
sir telegram pr query beji thi ..apne sbi tk dekhi nhi
@Innozant
3 жыл бұрын
Ht saate query aate h skip hua hoga .Will check it again and revert back yo
Sir Iferror formula array main kaam nahi karta hai, uska kya solution hai, any other option.
@Innozant
3 жыл бұрын
Kyu ..?
@hrhelpteam
3 жыл бұрын
@@Innozant ek baar check karke dekhiye sir normal mein kaam karta hai, array function main nhi karta hai sir
@Innozant
3 жыл бұрын
Ok .
Sir, jis sheet me aap smjhate hain us sheet ka link separate de diya kro practice ke liye. Please 🙏🙏🙏
@Innozant
3 жыл бұрын
Already diya hua hai .seprate direct link.broken ho gya hai m working on it.