Hi,
I want the data in one row to split to multiple rows and multiple columns
like for ex: my transposed data appear like this:
I want the product number 2 and its related data to come below product number 1 like a table. for ex: I want a out like how it is in the image.
I have given example for two products, but there could be many pdts around 200-300. I want pdts to come below the other. I am in need to solve this ASAP. Aany help is highly appreciated. any excel function or even VBA is also ok.
I want the data in one row to split to multiple rows and multiple columns
like for ex: my transposed data appear like this:
I want the product number 2 and its related data to come below product number 1 like a table. for ex: I want a out like how it is in the image.
I have given example for two products, but there could be many pdts around 200-300. I want pdts to come below the other. I am in need to solve this ASAP. Aany help is highly appreciated. any excel function or even VBA is also ok.