Help - Possible Macro or?? Concatenate + If formula?

**kbee859** · 05-22-2014, 08:00 PM

Hello,

I'm an intermediate excel user.

I am trying to reformat a spreadsheet that takes the following into consideration:

Column A is a name -- Column B is a description for the name in A, but covers multiple rows (was exported from a software program).

I need to come up with a formula that will recognize that if there is no value in Column A, that the text in B should be concatenated to the text in the row above, and that if the text in the row above was already concatenated to the row above that, then the text should be concatenated to that row instead (and so on and so forth).

Is this possible? Would save me around 10-15+ hours of cut and paste.

Thanks,
KB

**gak67** · 05-22-2014, 08:48 PM

Formula:

Please Login or Register  to view this content.

in C2 and below will give you the concatenated column B cells in the row before the next name, but it will have all the intermediate steps as well. To do what you want in the row with the name in it will require an array formula.

**gak67** · 05-22-2014, 09:04 PM

Formula:

Please Login or Register  to view this content.

should do it the other way.

**kbee859** · 05-23-2014, 09:40 AM

Thanks gak67 - I will work with this today - thanks so much for the help!

**Hawkeye16** · 05-23-2014, 10:07 AM

A macro would make an easy solution. Are you wanting to do this for every row in the sheet? Do you want the blank rows then deleted out after the concatenation happens?

If so something like this would work, assuming the data is on a tab called Sheet1

Please Login or Register  to view this content.

Always a good idea to make a test copy before running code that deletes information because there is no Undo for macro code.

Help - Possible Macro or?? Concatenate + If formula?

LinkBack

Thread Tools

Rate This Thread

Display

Help - Possible Macro or?? Concatenate + If formula?

Re: Help - Possible Macro or?? Concatenate + If formula?

Re: Help - Possible Macro or?? Concatenate + If formula?

Re: Help - Possible Macro or?? Concatenate + If formula?

Re: Help - Possible Macro or?? Concatenate + If formula?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to Concatenate, copy and paste the formula until the last row of the previous column

Macro problem using 'Concatenate' formula to calculate Age

CONCATENATE Macro or Formula

Macro concatenate formula

[SOLVED] using the value of a macro variable in a concatenate formula

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions