need macro for table

[abhisharma]

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 to ohter sheet

fname	lname	id	user
abhi	shar	789​	simple
abhi	shar	789​	simple
abhi	shar	789​	simple

 

[vletm]

abhisharma
Verify:
#1
Your input has three times 789
and
You output has four times 789.
#2
All output rows are same, except the header.

As You've read from Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
eg For the best/fastest results, Upload a Sample File ...
Means sample input data
and
expected output per Your sample input data.

 

[abhisharma]

it is like sample data
i need macro for displying data same output