Dear all, Cell A & B having data like below.please note that Data range of cell A & B is not fixed.
I want to get like below format in the Cell C
Please Login or Register to view this content.
Please check the attachment.Please Login or Register to view this content.
Last edited by nur2544; 04-11-2015 at 11:11 AM.
It won't do everything you are asking and the format will be slightly different... but did you consider using a Pivot table?
You can easily split the data by district that way...
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Hi GC Excel , it works for my case.thanks for your nice idea.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks