Transpose few Columns to Rows based on the values

[BMD44]

Hello All,

I have a sheet which has columns from 6 to 8 with certain values in it. Requirement is to bring these columns to the rows based on the values, excluding the blank values.

Attached the image. The first picture is how I currently have the data and I need to Transpose it as the 2nd image below.

I have tested the If logic in 'Tested' sheet, but that needs to be manually updated once the column value changes. We have 3 columns in sample file. In reality, we have more than 50 columns.

Can anyone please suggest a dynamic way of doing this.


Thanks in advance

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Transform certain Columns to Rows based on the values
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[BMD44]

Ok. Thanks.