Hello,
is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick
Please help me
Thanks in advance,
Cheers.
Hello,
is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick
Please help me
Thanks in advance,
Cheers.
Using Power Query/Get and Transform which is part of Excel 2013.
Mcode
You will have to unmerge cells as I have in your example. File attached.Please Login or Register to view this content.
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
Perfectly worked! Actually I didn't know that there's something called Power Query in Excel, I learned now thanks to you!!
but I have this problem now:
after I make the query and load the produced table made by Power Query, when I make some changes in values or Box Numbers I have to redo the process and copy/paste the new produced table by Power Query, is there any way to make Power Query refresh by itself on my target sheet without producing a new sheet in by Power Query?
I really really thank you very much.
There is solution based on formulas
Hello BMV,
I would like to thank you very very much for your efforts, I learned new functions which I didn't know before.
Thanks again for your help.
Reputation added.
If you use the refresh button on the Data Tab after updating the original data, it should update the query automatically. Thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks