ANmarS - Portfolio - 2Cols2ColRow

Excel/VBA expert since Sep 1997 (20 years 1 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2Cols2ColRow    Added: 8/20/2011 | Created: 4/15/2009   



Convert 2 columns table into Col-Row table using formulas only, no macros

In another word, convert:
Honda: ACCORD
Honda: CR-V
Honda: Pilot
NISSAN: Altima
NISSAN: Maxima

Into:
Honda - NISSAN
ACCORD - Altima
CR-V - Maxima
Pilot -

Very helpful if you have a long list and don't want to copy/paste


Download (5.3 KB)

1130 downloads | Last updated: 1/15/2014


Screen shots (6)