supag
09-14-2010, 04:29 AM
I am very new to vba and macros with excel. I have an excel file well its actually a text file but i can open it in excel and it pretty much formats it for me. See attached for how it looks. Basically it makes multiple rows for the same phone number rather then one row with multiple columns.
Can any one help me with a vba macro to take the multiple rows into 1 row per use/phone number. So for each phone number that has multiple rows make it into 1 row and take each "item description" and "used" column and make it into multiple columns. Sorry if this is confusing. I attached a excel file to make it more clear.
Thanks
Can any one help me with a vba macro to take the multiple rows into 1 row per use/phone number. So for each phone number that has multiple rows make it into 1 row and take each "item description" and "used" column and make it into multiple columns. Sorry if this is confusing. I attached a excel file to make it more clear.
Thanks