ANmarS - Portfolio - 2Cols2ColRow

Excel/VBA expert since Sep 1997 (21 years 3 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: CR-V
Honda: Pilot
NISSAN: Altima
NISSAN: Maxima

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)

1182 downloads | Last updated: 1/15/2014

Screen shots (6)