VB for removing and moving

[tsnorExcel]

Hi there - I have an Excel sheet which looks something like this:

HAving 3 colums i.e. Name | Number | Seq.

Name Number Seq.
Fred 1000 1
Fred 1000 2
Fred 1000 3
Tom 2000 1
Tom 2000 2
Tom 2000 3
Jane 3000 1
Jane 3000 2
Jane 3000 3

I want my result to show:

Having 2 colums i.e. Name | NumberSeq

Name NumberSeq
Fred 1000, 1, 2, 3
Tom 2000, 1, 2, 3
Jane 3000, 1, 2, 3

3 columns -> 2 cloums

Where i.e. "1000, 1, 2, 3" is one cell value.


Any ideas?

Thanks!!

BR
Thomas <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig --><!-- edit note -->

 

[iliace]

I would just put it in a pivot table (classic view or equivalent), everything in rows and turn off all summaries. Then copy, paste, and concatenate - and copy/paste values. It should take only a few minutes.

 

[tsnorExcel]

Hi Iliace,

Thank you for the reply.

I´ll give it a try.

Have a nice weekend.