need macro for below table

[abhisharma]

I have table like :-

fname	abhi
lname	shar
id	789​
user	simple
fname	udhay
lname	kumar
id	345​
user	minor
fname	rohan
lname	pandey
id	7123​
user	Super

I need macro to get output like on sheet2 :-

fname	lname	id	user
abhi	shar	789​	simple
udhay	kumar	345​	minor
rohan	pandey	7123​	Super

 

[vletm]

abhisharma
Do not duplicate Your thread, below Your orginal

need macro for table

Hi I need to show my data into excel like below with macro input is like fname abhi lname shar id 789 user simple fname abhi lname shar id 789 user simple fname abhi lname shar id 789 user simple Output should be like...

chandoo.org

This thread is closed.