Data consolidation in Excel | Ms Excel - Consolidation

[@AC-xw4ot]

Awesome approach to a tedious work. Thank you so much Sir
🙏

[@Innozant]

Thanks dear

[@asmrindia]

Very Nice Sir

[@rameshchandragoyal4494]

Very nice, superb

[@malcolmdevadas5903]

Sir when I tried using own data, after clicking to Data(CONSOLIDATE) Top Row & Left Column is getting Highlight but Create link to source data is not getting highlight to check box. What to do? Sir.....

[@sdsbma]

Sir when I flash fill year by following same method so resulted values shows in amount in thousands and make no sense I don't know where it comes from

[@OpPhilo03]

Sir, Last ke jo name hai Joe5, Joe6 iname keval year 2012 and 2013 ka data consolidate ho raha hai. Aisa kau?! Mai Kal se ise samajhane ki kosis kar raha hu lekin samajh nahi aa raha hai. Please bataye.

[@vsrjob]

Great

[@sitaramkohli9549]

Sir you are awesome 🙏 the the

[@Innozant]

Thanks Sita Ram ji.tc

[@RAKESHKUMAR-qw9cn]

Naming range one by one banana hoga ya kaise

[@Innozant]

One by one bhi select karke kar sakte hain lekin sbse best use kijiye create from selection..

[@RAKESHKUMAR-qw9cn]

@@Innozant VBA kab se start karoge

[@RAKESHKUMAR-qw9cn]

@@Innozant kaise karna hoga

[@Innozant]

Select the data set..formula -create from.selection.

[@jitendradore9529]

Sir
Mere pc me data consolidate option me link option nahi a raha

[@Innozant]

Which version ?

[@User.313Alamgir]

Sir please don't give permission for ads it's too much problematic, please.

[@someonefrom2002]

Pay him 20k per month he will disable ads

[@Letters_and_covers]

Better go for an online course bro, u won't get adds..

[@saurabh17sharma68]

🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@Innozant]

Thanks 🙏❤️🙂