Row Duplication based on Cell <>"" in Clumn +1 = TRUE

[nhoj]

Attached picture much better description than I can write. Looking to get data into a pivot friendly format via a vba loop. I don't have much experience with writing loops. Many thanks in advance!

2018-01-22 09_08_45-Example.xlsx - Saved.png

[MickG]

Try this for Results starting "A2".

Please Login or Register  to view this content.

Regards Mick

[LeoTaxi]

Other way

Please Login or Register  to view this content.

Kind regards
Leo

[daboho]

I am sorri to distrub how if i want save this treats to my favorit or to my list thank

[nhoj]

AWESOME thank you both a TON!

[nhoj]

Sorry about bringing this back, I thought I had it , but i'm getting a type mismatch error highlighting

Please Login or Register  to view this content.

when trying to run Leo's code. I'm sure it's my bad...the values in the target columns are text fields

[nhoj]

Looks like both are set up for integers. MickG, I would love to understand how Ray works. Looks awesome. and I can't find any definitions for it online

[daboho]

Please Login or Register  to view this content.

[nhoj]

Please Login or Register  to view this content.

Still getting a type mismatch

[LeoTaxi]

without file we only can guess

Kind regards
Leo

[nhoj]

without file we only can guess

Kind regards
Leo

Sorry about that. The attachment is exactly the data types and structure of the real. Stuff without headers extends out anywhere from a single column to column cc and rows continue down for several thousand.

Thanks so much in advance, sorry about bad presentation of the situation.

[LeoTaxi]

Try

Please Login or Register  to view this content.

Kind regards
Leo

[nhoj]

That worked great! Thank you. Only thing that i needed to do was separate all rows that only have one target (again my bad, bad example file) and then it worked like a charm!