Turn Columns into Rows, with a catch

[jasonwebber]

I'm trying to turn sales funnel stages into a "path", showing each stage of the sales funnel in a single row. Currently the date is in two columns (old stage and new stage) and the path is shown in the old stage as a single column, multiple rows. The catch is that the final stage is in the 'new stage' column. What I need is to get each stage in it's own cell in rows, not columns, and include the final stage as well. Attached is a spreadsheet that shows the exported data on the left and the desired data on the right. Hopefully someone can help.

[FlameRetired]

Hi, jasonwebber

Welcome to the forum.

I don't understand the description, and cannot relate it to the workbook. Could you re-upload with desired results hand-typed in?

Thanks.

[jasonwebber]

Dave, the results are typed in, it's the J-N columns that should be the output. Columns C-H is the raw data that needs to be transformed, and the bolded cells are what I'd like to get put into a single row. Hope that helps, and thanks in advance for your advice.

[FlameRetired]

I am just guessing that the live data does not follow a pattern "Stage #" where it follows position and numeric patterns as in the upload. Is that correct?

Edit In the meantime this works with the data and layout provided. Try this formula in J5 filled / copied across to N5

Please Login or Register  to view this content.

[jaslake]

Hi Jason

Welcome to the Forum!!!

A VBA solution...try this Code in the attached...CTRL +x will fire the Code.

Please Login or Register  to view this content.