And I kind of need to remove the empty cells in rows and then merge the last cells for every row and and the collumn name (date) beside each cell content example the CL or 1 Box or Bag so it would become CL/Wed:Feb-01 for example with 1 cell only but if multy data cells then like this: 1 Box/Fri:Feb-03, 1 Box/Sun:Feb-12 as an example.
below is what final result should be:
im lost with all the filtering attempts I tried from tutorials can you please point me in right direction if I can learn how to do this it will help me to handle many similer types of excel files that I need to edit this way too.
Can you please upload that Excel file as shown in the first screenshot? People are usually more inclined to help you if they do not have to type that all manually over again and also allows to properly validate any proposed solution
One way to solve it is via a column list loop and append each record with the column name and aggregate them afterwards.
Very good solution as well! One improvement I would make is to, due to the nature of the file, make the column selection dynamic with [A-Za-z]{3}:[A-Za-z]{3}.*