ExcelGuru516
New Member
Hello, everyone and thanks for having me! Thank you for helping as well!!
I am somewhat of a rookie to this.
I have a spreadsheet attached.
The first column contains a name. It then has a space and then another line of data. I would like the name to appear only on lines with data on them. Note, there is a name change every now and then. I need the code to copy the name relative to the data? Does anyone have a good code that can help with this? (in some cases you will notice multiple spaces with blank information. Anyone have an idea?? Thank you for your help!!!
I am somewhat of a rookie to this.
I have a spreadsheet attached.
The first column contains a name. It then has a space and then another line of data. I would like the name to appear only on lines with data on them. Note, there is a name change every now and then. I need the code to copy the name relative to the data? Does anyone have a good code that can help with this? (in some cases you will notice multiple spaces with blank information. Anyone have an idea?? Thank you for your help!!!