I need help with combining data and it cannot be using VB because it will be used in multiple computers. It has to be formula based and would be great if we could work it out. The input sheet will have 3 columns as shown but will always be of varying lengths and can increase further in size. The output sheet shows the example of what is needed. basically to incorporate that. How do I fix combine data if lengths is going to be dynamic?
Basically, it has to combine data in the order of A - B - C. This cannot change. but has to do it for all possible combinations. For example - A2-B2-C2, then A2-B2-C3 and so on. I hope this is clear enough. It would be great if some one could help me out with this.
Basically, it has to combine data in the order of A - B - C. This cannot change. but has to do it for all possible combinations. For example - A2-B2-C2, then A2-B2-C3 and so on. I hope this is clear enough. It would be great if some one could help me out with this.
