I have an excel sheet that i export from a program and need to clean it up.
I am having trouble and working for days. I need the data to look like what is in the second tab.The data in the first tab is the exported data. I can not find out how to merge and get everything on same row and only one row. This needs to be done via a macro. I have a lot of data but this is just some of it.
if i unmerge the worksheet it then puts the data on two separate rows . Then i do not know how to join the rows.
I would love to see the code so i can learn from it. This is driving me nuts .
Bookmarks