Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108012

Re: Merging rows and data vertically based on first sno column

Show all headers | View raw

hi,

the data are numeric or alphanumeric?

isabelle

Le 2015-09-04 15:50, semka a écrit :
> I need to concatenate data vertically in each row and per column (i.e
> retaining all data in merged cells, not just from top most cell) based on
> merged rows with a serial number in column A.
>
> So I have:
>
> A  B        C      D Data1    Data2  Data3 1  Data4    Data5  Data6 Data7
> Data8
>
> 2  Data9    Data10 Data11 Data12          Data13
>
> 3  Data14   Data15 Data16 Data17
>
>
> I'd like to have:
>
> A  B             C              D 1  Data(1+4+7)   Data(2+5+8)   Data(3+6) 2
> Data(9+12)    Data10        Data(11+13) 3  Data14        Data(15+17)
> Data16
>
> Could you please help me with a macro for that?
>

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Merging rows and data vertically based on first sno column semka <semion@gmail.com> - 2015-09-04 12:50 -0700
  Re: Merging rows and data vertically based on first sno column isabelle <i@v.invalid> - 2015-09-08 22:21 -0400

csiph-web