CSV file with two columns multiple values separated by pipe. Need to Combine

Run this macro on your data sheet, it will output to column C:

Please Login or Register  to view this content.

Hi nikythebest,

Here is another way to do this problem without needing any vba code. See the attached.

Start with your data on Sheet1.
Copy Column A from Sheet1 to Sheet2 and then Convert it to Text using the | delimiter.
Copy Column B from Sheet1 to Sheet3 and then Convert it to Text using the | delimiter.
Then on Sheet4 create a formula to combine Sheet 2 and 3 with a ":" in between each.

Then using Column A of Sheet 4 use my formula to rebuild to what you want and get rid of extra "|:" characters
Then in Column B go back to all the numbers in Sheet3 and simply sum them to get that last answer you wanted.

I hope this helps.

It is a little process but you don't need any VBA code to do it.

Originally Posted by nikythebest

I found out how to run that script. It is working perfect. Now can you please how to calculate SUM of stock. Thank you very much.

Your post #1 was clear and demonstrated your goal. You'll need to amend your sample workbook (it doesn't need to have that much sample data in it...) and manually mockup you actual final desired result. Don't keep "developing it" and moving the goal post, figure out now what you need it to look like and show us that.