Is it possible to club multiple columns and convert those in to HTML format?

%3CLINGO-SUB%20id%3D%22lingo-sub-2692401%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20club%20multiple%20columns%20and%20convert%20those%20in%20to%20HTML%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692401%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20a%20situation%20where%20I%20need%20to%20merge%20three%20columns%20row%20wise%20and%20make%20those%20in%20to%20HTML%20format%2C%20the%20reason%20I%20need%20this%20is%20to%20upload%20test%20cases%20to%20ADO(Azure%20DevOps).%3C%2FP%3E%3CP%3EPlease%20find%20the%20attached%20Sample%20file%20as%20a%20reference%20file%20and%20also%20expected%20result%20I%20am%20expecting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20in%20performing%20these%20actions%20through%20Macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20big%20thanks%20in%20advance%20to%20everyone.%3C%2FP%3E%3CP%3EFor%20example%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn1%26nbsp%3B%20Column2%26nbsp%3B%20Column3%3C%2FP%3E%3CP%3EABC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B123%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BXYZ%3C%2FP%3E%3CP%3EMMM%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BGGGG%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20HHHH%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20expectation%20here%20is%2C%20first%20three%20rows%20should%20be%20converted%20to%20HTML%20format%20first%20and%20it%20goes%20to%20second%20row%20and%20does%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20i%20said%20earlier%2C%20please%20find%20the%20same%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2692401%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2698094%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20club%20multiple%20columns%20and%20convert%20those%20in%20to%20HTML%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698094%22%20slang%3D%22en-US%22%3EPlease%20suggest%20or%20do%20help%20me%20on%20the%20above%20scenario.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%2C%20Kind%20request%20to%20you%20have%20a%20look%20and%20let%20me%20know%20if%20it%20possible%20to%20do%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello Everyone,

 

I am in a situation where I need to merge three columns row wise and make those in to HTML format, the reason I need this is to upload test cases to ADO(Azure DevOps).

Please find the attached Sample file as a reference file and also expected result I am expecting.

 

Please help in performing these actions through Macros.

 

A big thanks in advance to everyone.

For example:-

 

Column1  Column2  Column3

ABC           123           XYZ

MMM       GGGG      HHHH

 

My expectation here is, first three rows should be converted to HTML format first and it goes to second row and does the same.

 

As i said earlier, please find the same file.

 

 

 

 

2 Replies
Please suggest or do help me on the above scenario.
@Hans Vogelaar, Kind request to you have a look and let me know if it possible to do