Forum Discussion
MrExcel 2022 Boosting Excel Move Cells Upwards To Combine Entries Using VBA/formulas
I run a ticketing system that gives raw data as below : 1) Each ticket I.D. has 3 categories of waiting time, and some other details 2) If Ticket A has all 3 categories, then A to K of row 1-3 will...
Jacqq Perhaps you want to consider Power Query (PQ). If you create a structured table called "Tickets" with the exact same structure as in the attached example (RawData sheet, the blue table). I.e. 16 columns wide with headers "Column01" through "Column16", then the script should work. Columns 12 to 16 must contain the information specific to each category. Just press Refresh All on the Data ribbon, and review the result in the "TicketByRow" sheet (the green table).
It's a quick-and dirty-approach and I have not made any attempts to make it dynamic or very pretty. If you change the column names or add or delete columns it will break.