Hey all, I have two columns of information I am trying to combine and flash fill.
Column A which is a text string such as "Part 1", "Part 2", "Part 3" etc...
Column B is a material such as "Melamine", "Plywood", "MDF" etc...
I'd like to combine them so column A reads "Part 1 - Melamine", "Part 2 - Plywood", "Part 3 - MDF" and that when I flash fill column A it appends column B onto the description but also flash fills the numbering pattern of part 1, 2, 3.
Does that make sense?
I tried A1 as: ="Part_1"& "-" & B1 and it works for what it displays, so I then entered A2 as "Part_2"& "-" & B2. I then selected both cells and flash filled down to the end of my list which sometimes can be hundreds of parts but it doesnt recognize the pattern of the Part 1, Part 2, Part 3 to flash fill all the way to "Part 100"+. It just alternates Part 1 and Part 2 down the whole list.
Column A which is a text string such as "Part 1", "Part 2", "Part 3" etc...
Column B is a material such as "Melamine", "Plywood", "MDF" etc...
I'd like to combine them so column A reads "Part 1 - Melamine", "Part 2 - Plywood", "Part 3 - MDF" and that when I flash fill column A it appends column B onto the description but also flash fills the numbering pattern of part 1, 2, 3.
Does that make sense?
I tried A1 as: ="Part_1"& "-" & B1 and it works for what it displays, so I then entered A2 as "Part_2"& "-" & B2. I then selected both cells and flash filled down to the end of my list which sometimes can be hundreds of parts but it doesnt recognize the pattern of the Part 1, Part 2, Part 3 to flash fill all the way to "Part 100"+. It just alternates Part 1 and Part 2 down the whole list.
