Transpose multiple rows to columns sheet attached

[ahad_bwp]

hi everyone!
I tried searching the forum for the answer but I just could not find it...
I would be really grateful if someone could help me out!

I frequently have to work with tables set up like this:

Sr No. Account NAME ADDRESS

1 3657860000 MUHAMMAD 42-C NIL BLOCK Y MODEL TOWN
NADEEM CHUGHTAI Bahawalpur

2 4657860000 MUHAMMAD IRFAN NIL NIL BLOCK Y MODEL TOWN
city town bahawalpur
3 3347760000 MUHAMMAD ALI NIL NIL SADIQ PB RESIDENTIAL
Chugtai S/o Ahmed CLY AHMED PUR EAST ROAD
Bahawalpur
4 8943860000 BEGUM TARIQ 89-B NIL GHALLA MANDI MODEL
FAZAL QURESHI TOWN B
Bahawalpur
5 9943860000 MUHAMMAD IKRAM BV-2068 NIL GHALLA MANDI
MODEL TOWN B
Bahawalpur
i want to convert name and address rows to columns
sheet attached.......