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
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