(Solved) – Concatenate column A with each row of Column B

(solved)-–-concatenate-column-a-with-each-row-of-column-b

Data Set

Column A   Column B 
Name       Device1     
Type       Device2     
Date       Device3    
Colour     Device4
           Device5  

Result

Device1Name       Device2Name      Device3Name    
Device1Type       Device2Type      Device3Type  
Device1Date       Device2Date      ETC. 
Device1Colour     Device2Colour    

Trying to achieve this using a formula. Even VBA for that matter although I’m not sure where to start.
Is this easily possible? and how?

Leave a Reply

Your email address will not be published. Required fields are marked *