Parsing the xls into different worksheets

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the attached sheet, I want to parse with the criteria that in Column "C", for every unique "QTrace Messages Info" item a separate sheet should be created, including their corresponding Time and event.&nbsp;Thanks in Advance,Br,Anupam&nbsp;

lorenzo · Answer

anupambit1797&nbsp;&nbsp;Power Query, Transform still pending feedback/mark as solutionRe. this case one way in&nbsp;Power Query / Get &amp; Transform - Split Master as separate sheets

anupambit1797 · Answer

HiLorenzo , Could you please perform this operation in the attached sheet , Thanks!&nbsp;Br,Anupam

Forum Discussion

Parsing the xls into different worksheets

Share

Resources