User1 User2
----------------------------------------
Table1 Create 1 1
Table1 Alter 1
Table2 Create 1
Tabel2 Alter 1 1

What I need to do is substitute the 1's with the value in column 2 and,
ideally, if the tablename is the same (column1) put both values in column2
into 1 cell. I need to do this for a sheet with approx 30 columns (only 1st 2
have values as above) amd 3000+ rows.

I am somewhat familiar with macros and vb but this is beyond me (i think),
any pointers greatly appreciated.

have a good weekend!