I hope my excel was clearer, whenever my columns are blank i want those to be ignored and only the columns with Data to be transposed with corresponding header lines. I'm able to do all those but not able to get the header value as a column
thanks
I have a question on how to convert columns to rows, i tried and my macros was able to get most except for the header row. I would appreciate if anyone can help me where i'm having issues in my code. Also how do i upload my excel if i want to share what i'm trying to explain.
My data is like...
Hello all, I want to introduce myself as Sri and would like to learn practical excel, i do a bit of easy macros and formulas but want to do more complex stuff, would love to learn from a lot of experienced folks in this forum.
Thanks
Sri