Hi
I have a large datafile. In G column i have the data which i want to transpose. The transpose area from column G starts when B column has value 1 and ends before it gets the next value 1. I attach here an example of the dataset. There i have done the traspose manually but i am looking for a formula to do it. Thanks for the help.
Bookmarks