Macro to group the values in column by pipe delimeter

**anujv22** · 06-01-2016, 10:04 PM

Hi Experts,

I would need your help to develop a macro which group the rows of column B,C,D with pipe delimiter based on the values present in column A.

Basically, I want the output similar to a group by function in Oracle.

Appreciate all your help.

Attaching the link of sample data and the output I want.

https://drive.google.com/file/d/0BwQ...ew?usp=sharing

**karedog** · 06-01-2016, 11:12 PM

Maybe :

Please Login or Register  to view this content.

**anujv22** · 06-01-2016, 11:21 PM

Perfect!!

Thanks a Lot!!!

**karedog** · 06-01-2016, 11:39 PM

You are welcome, and thank you for marking this thread as solved.

Regards

Macro to group the values in column by pipe delimeter

LinkBack

Thread Tools

Rate This Thread

Display

Macro to group the values in column by pipe delimeter

Re: Macro to group the values in column by pipe delimeter

Re: Macro to group the values in column by pipe delimeter

Re: Macro to group the values in column by pipe delimeter

Thread Information

Users Browsing this Thread

Similar Threads

Macro to find group of 5 similar values repeating same in one column

Macro to add row after a group of texts in a column and sum values

[SOLVED] Any formula for making multiple column be single column separatef by pipe?

Macro to Group Rows Along a Range Based on Values in a Column

Macro to extract data into different tabs for each values in column D "Group"

Parse values either side of a delimeter.

Macro to import delimeter file

Bookmarks

Bookmarks

Posting Permissions