Macro to transpose rows into column

[yukycg]

I need to rearrange data into from rows into cloumns so I can use it in pivot table:

Original Data
Name Org
Jordan,Michael NBA
(space) Chicago
(space) Shooting Guard
Bryant, Kobe NBA
(space) LA
(space) Shooting Guard
(space) (space)
P., Greg NBA
(space) SA
(space) Staff
(space) Coach
Parker, Tony NBA
(space) SA
(space) Point Guard

I would like to become:
Name. Org. Team. Position. Title.
Michael Jordon NBA Chicago Shooting Guard
Kobe Bryant NBA LA Shooting Guard
Greg P. NBA SA Staff Coach
Tony Parker NBA SA Point Guard



I know how to do the name switch. I need help on the team arrangement.

Thanks for the help

[arlu1201]

Why dont you attach a sample file? It will be much easier for us to work on and provide you a solution quickly.

[reachharry]

Hi,

Please find attached the file where i have worked out to extract the information. Check out and let me know your thoughts..4

Regards,
Hariharan R

[arlu1201]

What are the numbers that you have provided in column L of the file? Also you do not need the name to be visible in the output?