I'de like to Transpose excel columns into a new list : I'm new at VBA and tried finding already existing solutions but none answered fully my requirements:
My initial list has holes (blanks)[enter image description here][1] and I need to list the results as transposed without these blank fields
column A has files # and then 5 columns with prices but some are having only one price others 2 others 3 etc but never more than 3 prices.

My first trials were no success as I couldn't find the totals expected.
Thanks for your help

  [1]: https://i.stack.imgur.com/dgmDL.png