How to the excel data please help me
In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure.
I can't upload the excel sheet that for i attached the IMG please help me

I mean my original data is column "A" to "K" and row 1 is heading row 2 to 5 is data

I want set data as per column "B" to "F" and row 7 is heading and row 8 to 22 is data
I want do it using formula I have 2000+ data
But I don't know how to do this I try many things don't get the result
Please help me sir

So you want to use a macro and you don't know how?

Bhai hindi mein hi Bata do kya poochhna chah rahe ho..samajh nahi aaya.

@Hammad, supply this in English too. Did you write "Tell your brother in Hindi only. What are you trying to ask..It did not understand."?