Have been perplexed by this one today...........Not sure how to execute it.........
I have a column of similar, grouped names. One row of them has a horizontal row of numbers like this
A B C D E This Product 1 Light 2 Light 3 Light 4 Light This Product This Product This Product That Product 4 Light 5 Light 8 Light 9 Light That Product That Product That Product
How do I concatenate the name with the different number of lights downward using the horizontal values as a fill in series? So Far, I have:
=IF($A$1:$A8=A1,CONCATENATE(A1&" "&......................
But from here I am lost............Anyone here got an idea of what i should be looking at as far as a Function to complete it like this??
A B C D E F This Product This Product 1 Light 1 Light 2 Light 3 Light 4 Light This Product This Product 2 Light This Product This Product 3 Light This Product This Product 4 Light That Product That Product 4 Light 4 Light 5 Light 8 Light 9 Light That Product That Product 5 Light That Product That Product 8 Light That Product That Product 9 Light
Thank you
Bookmarks