Dear Sir,
I have a problem, I have some data in one sheet divided into certain columns along with some BL nos., my problem is I need to get the Column Headers as rows in the next sheet and the totals of one particular BL no. should reflect in the next sheet rows of the same header.
I herewith attach the file for your reference please.
Regards,
Murali.
Copy, Paste--Transform would be one way of doing it.
Another maybe to look at PowerQuery--Get and Transform
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Dear Sir,
Copy Paste solution I am already doing that, but using H.Lookup and Index formulas I want your help to solve this problem.
Kindly help me. It is every day tedious work for me.
Please
Regards,
Murali
How do we know which BL to find this information for? There is no indication on either sheet? Please explain in simple English the business process so that we can provide you with an automated solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks