Hi all,
For better explaining the problem, I attached the short example. Please kindly take a look at the file and let me know how I can obtein the desired output, which is specified with blue color in the same sheet of file. Here, there are two columns, A and B (black color) as input data, which Y2, and Y3 is related to A1 and should be transposed to generate desired output (blue color). However, I have a large dataset and manullay transposing each part is really time-consuming. Could you please provide me a formula for doing the work?
Thank you
Bookmarks