Good day folks,
i am needing some transpose and concatenation help.
Car A Car A House A House B Car B House B
I wanted to create some results.
Each item in column A with each item in column B
so that it looks like the above
But i have failed to transpose and concatenate effectively.
Or is this better if i create a formula that i insert with vba?