Transpose rows with same column A but with a twist

[stan255]

Hi, how can we transpose rows with the same column A but in this structure?
transpose01.png

Here's a link to a sample workbook: transpose01.xlsx

[jindon]

Try

Please Login or Register  to view this content.

[stan255]

Hey jindon, I think it works!
How can we make it so that the transpose starts from column A in a new sheet instead of column F like the example picture?

[jindon]

Please Login or Register  to view this content.

[stan255]

Perfect, jindon! +rep