Have a user who used Excel like lined paper. For each "record, " one column could have between one and 20 cells. I need to turn this spreadsheet into a one-row-is-one-record sheet.
Is there a way to create a macro or function that says "concatenate cells from the column to the left until you get to a blank cell OR a dark formatted line"?
In the attached example image, the first two columns are indicative of the data. No standard number of rows or cells.... Cell C2, in red, is what I'm hoping to create from the data.
Is it doable? Thank you.
Is there a way to create a macro or function that says "concatenate cells from the column to the left until you get to a blank cell OR a dark formatted line"?
In the attached example image, the first two columns are indicative of the data. No standard number of rows or cells.... Cell C2, in red, is what I'm hoping to create from the data.
Is it doable? Thank you.