• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Transpose based on substring value

S. Das

Active Member
Hi,
I want to transpose Excel data which size is irregular, but a portion of the string ("test_dns") is common at the starting of each data range.
I want the macro to be paste values containing "test_dns" (this is just a portion of the string, which can be anywhere in the string) row by row and the intermediate data should paste column by column. After finding the next string containing "test_dns" the line will be changed.
Please go through the attached file for a better understanding

Feel free to ask any further questions.

Thanks in advance.
Sayan
 

Attachments

  • Transpose in Excel VBA.xlsm
    18.4 KB · Views: 12
Hi,​
explain first why some data in column D do not exactly match source data in column A …​
 
Back
Top